Formula of result by using a condition.

Asked By nurehasan 0 points N/A Posted on - 08/22/2011

I am using a Microsoft Excel document by using office 2003.

Here, I have three fields (Name, Total Number, Result).

Now I want to use a formula in result field which can be displayed that 40% out of 1000 will Pass and below 40% will Fail.

What can I do to solve this problem?

• Status: Open
• Question Views: 824
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by joestini

Go To Solution

Answered By edwardharmon 0 points N/A #116548

Formula of result by using a condition.

Suppose you have those figures on your cells and want to have that kind of formatting. Use the formula "If( condition, value_if_true, value_if_false )" and type it on the formula bar. Let's say on your end, your result should be displayed on the C column down.

Based on your figure, go to cell C2 and on the formula bar type the formula "=If( B2>=400, "Pass", "Fail" )".

Since your passing is 40% of 1000 so that is 400 out of 1000.

So, if on the B column (since it is the cell that we are going to evaluate) is greater than or equal to 400 then it would return a value as true, hence the value of  "Pass" and if false it returns as "Fail".

Hope this helps.

Thank you

About edwardharmon

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/22/2011
• Question Category: MS Excel

Best Answer

Best Answer

Answered By joestini 0 points N/A #116549

Formula of result by using a condition.

Solution

• You need to use a function in order to do this. The Excel Iff functions takes the format =if(test condition, value if true, value if false).
• In this case, your test condition is whether the total mark is less than 40% of 1000. The value if true is "fail" and the value if false is 'pass".
• You will therefore need to use the formula: =IF (B2< 40%*1000,"fail","pass") typed in cell C2. The formula is the copied and pasted to the rest of the cells.

Notice that

• Since the "pass" and "fail" are characters strings, they are in quotes.
• Instead of 40%*1000, you could as well have used 400

About joestini

Questions
2

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/22/2011
• Question Category: MS Excel