How can I add a return Blue if all these arguments are false?
IF(SUM(ColumnA@row) > (ColumnB@row + ColumnC@row), "Red", IF(SUM(ColumnB@row) > (ColumnA@row + ColumnC@row), "Green", IF(SUM(ColumnC@row) > (ColumnB@row + ColumnA@row), "Yellow")))
Thank you :)
Tags:
Answers
-
Hi JoAnneA,
You could combine all of the ifs you listed above with =IF(AND......but reversing them such as:
=IF(AND(B>A, B<(A+C), C<(B+A))) >>>>>Blue
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!