Microsoft Excel Question:
Download Questions PDF

I wrote the following formula in microsoft excel
=if(and(a1>39, b1>39, c1>39), "passed", "failed" if i enter numbers in the respective cells the formula works but when i entered x in the respective cells there is a problem. excel take x as a number. pls help?


No Answer is Posted For this Question
Be the First to Post Your Answer Now

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?Why do i get ##### instead of the sum?