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