Help with If Statement
 

I have inserted an IF statement, =IF(P80,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

Help with If Statement
 

=IF(P80,P8-U8,"")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"joemsewi" wrote in message
...
I have inserted an IF statement, =IF(P80,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

Help with If Statement
 

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

"joemsewi" wrote:

I have inserted an IF statement, =IF(P80,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

Help with If Statement
 

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

Jim K

"joemsewi" wrote:

I have inserted an IF statement, =IF(P80,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