Help Me Y'all! (Nested If functions)


#1

I’m doin a playoff project in excel and one of my formulas is:

=IF(C9>E9,“Miami”,IF(C9=E9,"",“Atlanta”))

The formula works, but the problem is that “Miami” and “Atlanta” need to be variable, and show the result of whatever team is shown in cell B7 or E7. What can i enter instead of those examples into the speachmarks to make it show whats in those cells without changing the formula.

Thank you for your help


#2

Hi, I don’t understand your question clearly.

How about “=IF(C9>E9, B7,IF(C9=E9,”",E7)) "?