View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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