alvin l nunley
Site Supporter
I want a cell to display different text based on 3 different conditions. I can do 2, but can’t make it to three.
This is what I have been working with.
=IF(B5>1,"Totals from calculated corner weights",orIF(A5>1,"Totals from 4 input corners")),orIF(A5+B5<1,"wait")
The first two if’s work, but adding the third blows it
Comments, compliments, criticisms and questions always welcome.
This is what I have been working with.
=IF(B5>1,"Totals from calculated corner weights",orIF(A5>1,"Totals from 4 input corners")),orIF(A5+B5<1,"wait")
The first two if’s work, but adding the third blows it
Comments, compliments, criticisms and questions always welcome.