Formula help, display nothing if no data

  • Thread starter Thread starter MrJim005
  • Start date Start date
M

MrJim005

Hi
I want a cell to display nothing if there is no data in a certain cell..

4100 - 4200 + 99 = -1 / if nothing is in the cell for 4100 then the sum
returned should be nothing

=F8-F7+J8 - if nothing is in F8 the cell should display nothing.

Thank
You
 
=IF(F8="","",F8-F7+J8)

If F8 could contain anything but a number

=IF(ISNUMBER(F8),F8-F7+J8,"")


Gord Dibben MS Excel MVP
 
Back
Top