IF excel formula like IF C6 70 Pass Fail throws error

0 votes

I am trying to use a simple IF formula in a cell but I get This is not a formula error.

This is the IF I am trying (C6 is empty):

=IF(C6>=70,"Pass","Fail")

What I really need is a formula that calculate multiplication between two cells or empty cells depending on value of one of the two cells.
Something like:

=IF(G12=1,D2*G12,"")

Apr 5 in Database by Edureka
• 9,700 points
13 views

1 answer to this question.

0 votes

Using Excel's IF & AND function Assume you have a table containing the results of two exams. The initial score, which is stored in column C, must be at least 20. The second score, which appears in column D, must be at least 30. A student passes the final test only if both of the above conditions are met.

The simplest approach to create a suitable formula is to write out the condition first, then incorporate it into your IF function's logical test argument:

AND(B2>=20, C2>=30) is a condition.

The IF/AND formula is as follows:

=IF((AND(C2>=20, D2>=30)), "Pass", "Fail") 

Excel IF function with multiple AND conditions

answered Apr 6 by Edureka
• 8,820 points

Related Questions In Database

0 votes
0 answers

If Cell Starts with Text String... Formula

I have formula that checks if the ...READ MORE

Feb 24 in Database by Edureka
• 9,700 points
13 views
0 votes
1 answer

MS Excel - SumProduct formula with Loop

Drag this to the right of cell ...READ MORE

answered Mar 14 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

answered Mar 15 in Database by Edureka
• 8,820 points
28 views
0 votes
1 answer

Excel formula to remove comma, spaces, period and add a text

The steps to accomplish this are as ...READ MORE

answered Mar 15 in Database by Edureka
• 8,820 points
52 views
0 votes
1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

answered Mar 15 in Database by Edureka
• 8,820 points
55 views
0 votes
1 answer

Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

answered Mar 15 in Database by Edureka
• 8,820 points
34 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

how do I calculate discount with if function in excel?

Suppose a customer gets a 10 percent ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
193 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP