Nest the IF function
how do I nest the if function?
Cell A1 do this if it is >5000 AND A1< 1000000 “xx” and do this if it is > 1000000, “yy”, else do this - “"
[Re-Titled by Moderator]
Original Title: Nest the IF function
MacBook Air 15″
Question marked as
Another option would be to attack it backwards.
If A1>=1000000 then "yy" else if A1>5000 then "xx" else ""
=IF(A1>=1000000, "yy", IF(A1>5000, "xx",""))
or
=IFS(A1>=1000000, "yy", A1>5000, "xx", TRUE, "")
