IF Statements using BUT - is there such a thing

  • Thread starter Thread starter esulpher
  • Start date Start date
E

esulpher

I am trying to use an IF statement involving two arguments - IF Cell X
is = "blank" then bring back the SUM of Cells XX-XX BUT IF Cell X
[this is the same cell as the first reference] is = "non blank" the
bring back the SUM of Cells YY-YY. Is this possible? If so how woul
I do this?

Thank yo
 
Well, cell XX is either blank or it's not, so:

=IF(XX="",SUM(YY:YY),SUM(ZZ:ZZ))

Regards

Trevor
 

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

SUMIF "value if false" not working 2
My formula returns a result but the cell displays a zero? 15
If or conditional formatting? 5
If Then Formula Question 1
IF STATEMENT 6
"IF" help 2
If then statement 2
IF Statements using previous cell references 1

Back
Top