IF Statements using BUT - is there such a thing

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
 
T

Trevor Shuttleworth

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

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

Regards

Trevor
 
Top