IF with OR - Microsoft Community


gender eng maths sch. 10000? sch 5000? if (scholar / dumb?)
m 78 89 false true dumb
f 98 98 true true dumb
m 89 80 false true dumb
m 65 67 false false dumb

q.my if function taking false value ,however i've used 'or' function ,kindly help 

=if(or(e3="true",f3="true"),"scholar","dumb")

ignore "true" , use true below in g3 cell , copy down:
=if(or(e3=true,f3=true),"scholar","dumb")


Office / Excel / Windows 10 / Office 2016



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

Activation Error 0x8004FE93 - Microsoft Community