If... Blank return
 

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

If... Blank return
 

HI Alec,

You don't need the SUM

Try this:

=IF(Formulas!P13<1,"",$S$5)

--
Kind regards,

Niek Otten


"Alec H" wrote in
message ...

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

If... Blank return
 

HI Alec,

You don't need the SUM

Try this:

=IF(Formulas!P13<1,"",$S$5)

--
Kind regards,

Niek Otten



Sorted, thanks Nick :)


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