Formula help, display nothing if no data

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
 
G

Gord Dibben

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

If F8 could contain anything but a number

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Newbie Help - IF Yes No Function 0
Filtered view of Visio Chart 0
Conditional Formatting Formula 2
Need help with a formula 3
Copy addition formula of non-consecutive horizontal cells 2
SUMPRODUCT 0
Copy condtional formatting in XL2007 for Windows 1

Top