IF function with three outputs

Question

I'm trying to use a function that will allow three outputs based on the values in two different cells.

=IF(AND(H2>I2),-27,-11,IF(AND(H2=0,I2=0))

This is the formula I'm trying, but it tells me I have an error.  I can get the first part to work, but not the second half.

If H2 has a balance I want the value to be -27, if I2 has a balance I want the value to be -11, if neither H2 or I2 have a balance I want the value to be 0. 

Any suggestions?  Thanks in advance!

Answer 1

You didn't mention what you wanted if both H2 and I2 have a balance, so this formula doesn't account for that, but this will do the rest of what you want in the order of checking H2 first, and then I2:

=IF(H2<>"",-27,IF(I2<>"",-11,0))

Answer 2

They will never both have a balance at the same time.  Thank you so much!  That worked!

Answer 3

Good to hear