The If function

  • Thread starter Thread starter compaq
  • Start date Start date
C

compaq

I have 3 columns, (A) which has calendar months, (B) which is a cost
figure for that month and (C) a “higher” or “lower” statement on that
months cost compared to the previous months.

I have used the formula =IF(C2>C3,"higher","lower") to show this, which
works, but where I have copied this formula down to the other cells.

The problem I want to rsolve is that in months where there is no data,
it defaults to a Worse statement, I require it to be empty.

I use this spreadsheet on my pocket pc, so it does not support VB or
conditional formatting. Is there a way of only allowing the statement
if there is data in the cells. I have used the isnumber function, but
this does not work.

Any help appreciated.


Thanks.
 
Hi Again,

Thanks for responding, both formulas work, so thanks for that.

I seem to have another problem though, if I have data that is the same,
it defaults to Lower. Can I get a third Text to appear "Same"?

Thanks again.
 
=IF(COUNT(C2:C3)=2,IF(C2>C3,"higher",IF(C2<C3,"lower","same")))

Vaya con Dios,
Chuck, CABGx3
 
CLR said:
=IF(COUNT(C2:C3)=2,IF(C2>C3,"higher",IF(C2<C3,"lower","same")))

Vaya con Dios,
Chuck, CABGx3


Hi,

Thanks for the response. Your suggestion works, but I have my original
problem, in future months without data, it defaults to "false" where I
need it to be blank.


Thanks
Click to expand...
 
Back
Top