The If function

Giganews Newsgroups
Subject: The If function
Posted by:  compaq (compaq.29hprb_1150453201.7041@excelforum-nospam.com)
Date: Fri, 16 Jun 2006

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?action=getinfo&userid=35484
View this thread:http://www.excelforum.com/showthread.php?threadid=552604

Replies