Help with If Statement

[joemsewi]

I have inserted an IF statement, =IF(P8>0,P8-U8), in a spreadsheet cell. In
the spreadsheet cell if P8 = 0 the FALSE statement appears. I would like to
eliminate the FALSE statement from the cell contents and only show contents
in that cell if P8 >0. How can I do this?

Thank you

 

[Don Guillett]

=IF(P8>0,P8-U8,"")

 

[FSt1]

hi
you don't have enough arguments in the statement.
the aguments are....
if(condition, true, false)
all you have is.....
if(condition,true)
excel seems to be filling in the blank.
try this.
=IF(P8>=0,"",P8-U8)

regards
FSt1

 

[jknkboaters]

For the False condition, use P8
=IF(P8>0,P8-U8,P8)

Jim K