Help with Formulae

K

k f h

Hi All,

I know this going to be easy for you guys but I'm stuck on it.
How do I write this formulae.
If the total number of places available for each class is zero, then the
result None should be returned, otherwise the actual total should be
displayed.
The cells are F20:G20. F20=69 G20=22. the answer needs to be replicated
neither cell is absolute.

Thanks,

kfh.
 
D

Daz

Firstly ensure the cell you write the formula into is set to type general.
add formula =if(test formula,answer if test is true,answer if test is false).
eg =IF(SUM(F20:G20)=0,"None",SUM(F20:G20)).
If the cell type is not set to general the formula will not be evaluated and
it will not be able to display both numberic and text results.
 
K

k f h

Hi Daz,

Thanks for that.

kfh


Daz said:
Firstly ensure the cell you write the formula into is set to type general.
add formula =if(test formula,answer if test is true,answer if test is false).
eg =IF(SUM(F20:G20)=0,"None",SUM(F20:G20)).
If the cell type is not set to general the formula will not be evaluated and
it will not be able to display both numberic and text results.
Click to expand...
 
Top