software

Hi,

I have created a If... formula for one of my worksheets, it currently
reads as follows:

=SUM(IF(Formulas!P13lt;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: www.excelforum.com/member.php...oamp;userid=31042
View this thread: www.excelforum.com/showthread...hreadid=516134HI Alec,

You don't need the SUM

Try this:

=IF(Formulas!P13lt;1,quot;quot;,$S$5)

--
Kind regards,

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

HI Alec,

You don't need the SUM

Try this:

=IF(Formulas!P13lt;1,quot;quot;,$S$5)

--
Kind regards,

Niek Otten
Sorted, thanks Nick --
Alec H
------------------------------------------------------------------------
Alec H's Profile: www.excelforum.com/member.php...oamp;userid=31042
View this thread: www.excelforum.com/showthread...hreadid=516134