The If function

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.
 
C

compaq

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.
 
G

Guest

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

Vaya con Dios,
Chuck, CABGx3
 
C

compaq

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Function 1
If statement with dates 0
IF function 1
Excel VBA 1
using if for multiple criteria 22
if statements using words 2
return empty string value if cell is blank 2
If function to evaluate if date is today or six months back 6

Top