IF NOT THEN

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

Guest

How can I have a formula include data when applicable and at the same time
when that cell does not apply to have it default to another cell to calculate
a sum ?
 
Dave Thanks, One more thing Now I need the opposite if A1 has a value How do
I write the logic for that.
 
I'm not sure what you mean by "the opposite". The formula I gave in my
earlier response tests to see if A1 has a value....

Dave
 
Dave, If A1 has a and that value needs to be added to create a sum how do I
creat that. Sorry for not being clear
 
=IF(A1=10,A1+B1,C1+B1)

If A1 equals 10 then add A1 and B1

If A1 not equal to 10 then add C1 and B1


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Excel formula, sum the value cell and if empty cell left blank 0
Select a range not equal to: 4
using the =page! feature to transpose a row to column 0
Time Sum in Excel 1
Creating a formula relating to several cells 2
Form. to ignore cells w/o value from calc from previous Form. 2
sumif and complex sum_range formulae 2
Excel How to add numbers in same cell? 2

Back
Top