If then with 2 comparisons

[Brett Olsen]

How can I compare 2 things at once in the logic test of my IF/Then
statement? e.g. If(E43>G43ANDI43,"Site One",If(G43>E43ANDI43,"Site
Two","Site Three"))

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Frank Kabel]

Hi
try
=IF(AND(E43>G43,E43>I43),"Site One",IF(AND(G43>E43,G43>I43, "Site
Two","Site Three"))