Log In
Register
Home
August 14, 2019
Offline
Hello,
Can you please let me know what the formula is to have the result be "White & Yellow" if the White and Yellow columns are True, "White" if the White column is TRUE and the Yellow column is FALSE, "Yellow" if the White column is FALSE and the Yellow column is TRUE, and the "Neither" if both the White & Yellow columns are "FALSE"?
Thanks,
Trusted Members
December 20, 2019
Offline
Probably a couple of ways to do it and some will depend on what version of excel you have.
The way that should work in all version is the nested ifs with and's
=IF(AND(A2=TRUE,B2=TRUE),"White & yellow", IF(A2=TRUE,"White",IF(B2=TRUE,"Yellow", IF(AND(A2=FALSE,B2=FALSE),"Neither"))))
You don’t really need the last if(and) as it you can have it as a default, but I tend you use the last default as an error checker if there is only a small number of options - i.e. if I have done something wrong the formula will say FALSE
Purfleet
VIP
Trusted Members
December 7, 2016
Offline
Hello,
In case you have Excel 2016 or newer you can use IFS function.
https://www.myonlinetraininghu.....s-function
1 Guest(s)
