IF with OR - Microsoft Community
Office / Excel / Windows 10 / Office 2016
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")
Office / Excel / Windows 10 / Office 2016
Comments
Post a Comment