You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I have 2 columns.
Depending upon data in other cells, these 2 columns will either have a No or a Yes in the cells within the columns.
So, in another column, I want Excel to basically identify where No appears in both cells F4 & I4 (as an example).
My mind is fried, so would appreciate your help folks. Thanks!
=if(and(f4="No", i4=“No"), "Both No", "Not both No")
change the "both no" and "not both no" values to suit
A) change no yes to true false because they're useful/actual values.
That aside
b) =if(and(f4="no",i4="no"),"absolutely not","ask your mother")
(you don't need " around true and false, you could also =f4+i4 with true false giving 2 [true true] 1 [true false] or 0 [false false] as outputs or multiply for 1 [true true] or 0 [true false or false false], so can ditch the and in favour of of=if(i4+f4=0," absolutely not", "ask your mother")
Thanks both - much appreciated.
If you're using true/false you can simplify things with logic statements.
For your example NOT(OR(A1,B1)) outputs TRUE if A1 and B1 are FALSE.
OR would give you true if one is true and AND is true if both are. Extends to more columns if you want.