•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Nesting multiple AND/IF/OR statements
Current formula: =IF(AND(OR(J2=$AE$3,J2=$AE$4),AC2<49,AB2<>"CRMBOOK"),$AE$5,$J$2)
Formula looks for two different values in column J, confirms AC is less than 49 and AB does not contain the text "CRMBOOK". If those conditions are true or false it retrieves the respective cells. This works perfect.
Now what I'm trying to add here is another condition, where it would look for specific values in column I, and depending on if they are present or not it would change the value of the true reference. I can't figure out the nesting and its driving me nuts...
Current:
Future: (depending on the value in column I, I want to reference a different value in column AE)
Appreciate the help!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#formula generator
#rows.com
#Excel compatibility
#Excel alternatives
#formula
#IF
#AND
#OR
#column J
#column I
#column AE
#AC2
#AB2
#CRMBOOK
#nesting
#conditions