Another IF statement needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In M5 I need to add to the existing formula of =$L$1-G5 this: If there is
any number at all in N5, then M5 will be blank, otherwise it will calculate
$L$1-G5.
 
Thank you! Thank you! Thank you! You all know your stuff! You all came up
with the same answer!
 

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

Help with look up formula 3
display 0 instead of #DIV/0! 9
Sum cells based on number of months 6
Formula to change date when other cells are modifed 9
Automatically add lines and keep formulas 2
Picking out old dates 3
data from 1 sheet to the next 6
lookup question 1

Back
Top