Nested IF and
I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine:
=IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")
But now if I try to nest another I/AND statement like below, I get
=IF(AND([Status1]1 = "Low"; [Status2]1 = "Low"); "Low"; " "; IF(AND([Status1]1 = "High"; [Status2]1 = "High"); "High"; " "))
I Get #INCORRECT ARGUMENT SET.
Please assist what wrong with my formula.
Comments
-
Hi,
I came up with 2 solutions to this question - using IF/AND and another using concatenation -
- =IF(AND([Status1]8 = "Low", [Status2]8 = "Low"), "Low", IF(AND([Status1]8 = "High", [Status2]8 = "High"), "High", ""))
- =IF([Status1]1 + [Status2]1 = "LowLow", "Low", IF([Status1]1 + [Status2]1 = "HighHigh", "High", ""))
See images - I hope this helps.
Sean
-
Hi, Thank you for your assistance both solutions worked and I can see where I making a mistake.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!