The If function

**compaq** · 06-16-2006, 06:17 AM

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.

**SamuelT** · 06-16-2006, 06:47 AM

Hi,

Try this:

=IF(C2="","",IF(C2>C3,"higher","lower"))

**compaq** · 06-16-2006, 07:15 AM

Originally Posted by SamuelT

Hi,

Try this:

=IF(C2="","",IF(C2>C3,"higher","lower"))

Works a treat, thank you for your help.

CLR · 06-16-2006, 07:35 AM

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

Vaya con Dios,
Chuck, CABGx3

"compaq" wrote:

>
> 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.
>
>
> --
> compaq
> ------------------------------------------------------------------------
> compaq's Profile: http://www.excelforum.com/member.php...o&userid=35484
> View this thread: http://www.excelforum.com/showthread...hreadid=552604
>
>

**compaq** · 06-16-2006, 08:32 AM

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.

CLR · 06-16-2006, 08:50 AM

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

Vaya con Dios,
Chuck, CABGx3

"compaq" wrote:

>
> 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.
>
>
> --
> compaq
> ------------------------------------------------------------------------
> compaq's Profile: http://www.excelforum.com/member.php...o&userid=35484
> View this thread: http://www.excelforum.com/showthread...hreadid=552604
>
>

**compaq** · 06-16-2006, 09:11 AM

[QUOTE=CLR]=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