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?

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home MS Excel

⟩ 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?

Is this answer helpful?
0 Yes | 0 No

190 views

More Questions for you:

How do I tell the Office Assistant to go away?

How can I change settings, turn features off or on, and alter the way Word behaves?

How do I get Word to stop helping me type?

Can I add or remove buttons from the toolbars in MS Office?

How can I display more toolbars?

Can I turn the Ruler off (or turn it back on)?

How do I change the default document font in MS Office?

How do I move the toolbars in MS Office?

How can I find out what the buttons on the toolbars do?

How can I find out the names of the buttons on the toolbars?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home MS Excel

⟩ 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?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home MS Excel

⟩ 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?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: