IF function ?
Dear All,
I have the following task to solve. I have variable data in one cell which used for further calculation. There are basically only two variants 30 or 60. If the value is 30 the callculation needs to be ((cell1+cell2)*2)*60, if it is 60 the calculation is cell1+cell2*60. Cell1 and cell2 independent, but the calculation depends on the given value (30 or60) in another cell. Which formula would you suggest to use?
Dear All, I have the following task to solve. I have variable data in one cell which used for further calculation. There are basically only two variants 30 or 60. If the value is 30 the callculation needs to be ((cell1+cell2)*2)*60, if it is 60 the calculation is cell1+cell2*60. Cell1 and cell2 independent, but the calculation depends on the given value (30 or60) in another cell. Which formula would you suggest to use? Read More