Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
want to return "n/a" or "0" | New Users to Excel | |||
enter numbers in blank cells | Excel Worksheet Functions | |||
How do I return a blank for VLOOKUP instead of #N/A? | Excel Worksheet Functions | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
referencing cells that return blank results | Excel Worksheet Functions |