answersLogoWhite

0


Best Answer

You would use the IF function. Suppose the mark you want to check is in cell B2 as a percentage. Say the pass mark is 40%. Then in another cell you could have this formula:

=IF(B2>=40%,"Pass","Fail")

In the cell it will then display either the word Pass or Fail.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you give condition in ms - excel to find pass or fail?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Could you give me a sentence for the word fail?

I do not like it when i fail my math test.


Is it possible to grph data in Microsoft Excel 2003?

All versions of Excel give you lots of ways of creating graphs, which Excel refers to as charts.


How do you get trials?

Give up you fail ;)


What do you do if you cant find the median?

Give up on any hope of ever being a statistician. Oh, and probably also fail your math class.


What is the opposite of to manage?

Fail or Give up


Can you give a sentence with the word fail?

Any student engaged in plagiarizing answers deserves to fail.


How can you stop one excel workbook from interfering with another excel workbook when saving updates?

Give each workbook a different name.


What is the antonym of vanquish?

fail , surrender , give up


What is the opposite of fail?

The opposite of the verb "to fail" is normally to succeed.Where fail is used to mean give out, or become inoperative, the opposite is either to endure (not fail) or to restore (bring back from failure).


Where can I find online information about amortization schedule for excel?

Simply visit a Microsoft office site about Amortization and it will give you a template. Fill in your information. For further information visit http://office.microsoft.com/en-us/excel-help/using-the-loan-amortization-and-loan-analysis-templates-HA001034640.aspx. Read this page thoroughly to understand the use of excel properly.


What did the policy appeasment give Britain a chance to do?

because they fail


How do you make someone fail a test in school?

give them the wrong answer?