Multiple IF AND Nesting Formulas
Trying to return a number based on the GVWR column, we have multiple GVWR's and want to return differnt numbers in the TARE column. I keep getting a syntax error and can't figure out why. Ultimately there will be 5 options, showing two below. It works with one IF formula.
=IF(GVWR@row = 9500, 5840), IF(AND(GVWR@row = 9950, 6740))
Answers
-
@Steve_B1 Good morning, I am sure we can come up with something for you but I need a bit more information. Would you be able to share a screenshot of the sheet, dummy data is fine it helps a lot.
Also in the TARE column, what are the 5 options you would like to add, in the above formula there isn't anything defined if true other than another if(and statement so I am not sure what should populate if the first if is satisfied.
Thanks,
-
Where are you wanting your TRUE/FALSE to live in your equation? Right now you have if =IF(GVWR@row = 9500, 5840) is true then run another if. IF you are wanting the statement to be True based on both GVWR statements being true, then you need to move your AND statement.
=IF(AND(GVWR@row = 9500, GVWR@row = 9950),"5840,6740",FALSE)
-
Here is the whole formula with all 5 options
=IF(AND(GVWR@row = 6050, 6050), IF(AND(GVWR@row = 6500, 6500), IF(AND(GVWR@row = 9500, 5840), IF(AND(GVWR@row = 9950, 6740), IF(AND(GVWR@row = 10360, 6770))))))
-
@Steve_B1 Gotcha, the and was throwing me off there a bit sorry about that..
Is this what you're looking for?
=IF(GVWR@row = 6050, "6050", IF(GVWR@row = 6500, "6500", IF(GVWR@row = 9500, "5840", IF(GVWR@row = 9950, "6740", IF(GVWR@row = 10360, "6770")))))
-
Yes, thank you! I thought "" were only necessary for text.
-
Yea, you dont have to use the "" its habit I was going to update the post but I figured if you asked I would just reply. If you want a number just leave the "" off, my mistake..
-
Great, thanks again for the help!
-
@Cory Page Thank you. I was away, but the clarification on the use of the AND statement definitely helped.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hi! I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anyt…
- This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NE…
- Hi All! I´m trying to find the error in this formula but have not been able to find the solution after many attempts. Any ideas? =IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF(…