IF excel formula like IF C6 70 Pass Fail throws error

Question

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,"")

Answer 1

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")