Forum Discussion
How to write this Nested IF FUNCTION?
Hi guys, I need help writing a Nested IF function. for Afluence and Adventerous. The question is, write a nested if function that will input "Charcuterie" in the cell for females from San Francisco...
you can start with something like this. =IF(AND(OR(G5={"San Francisco","Palatine","Characuterie"}),OR(N5>125000,O5="Single")),TRUE,FALSE)
you can change the TRUE and FALSE to whatever variable you want to replace it with.