If... Blank return

[Alec H]

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

 

[Niek Otten]

HI Alec,

You don't need the SUM

Try this:

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

 

[Alec H]

HI Alec,

You don't need the SUM

Try this:

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

--
Kind regards,

Niek Otten



Sorted, thanks Nick :