Hi,
I have created a If... formula for one of my worksheets, it currently
reads as follows:
=SUM(IF(Formulas!P13<1,0,$S$5))
As a result the cell fills either with 0 if cell P13 has a value less
than 1 or fills with cell S5's data if P13 has a value of 1 or more.
What I want it to do is show a BLANK cell if P13 is less than 1 rather
than the 0 that it displays currently.
Very simple....but then so am I
--
Alec H
------------------------------------------------------------------------
Alec H's Profile:
http://www.excelforum.com/member.php...o&userid=31042
View this thread:
http://www.excelforum.com/showthread...hreadid=516134