IF formula Syntax

[Mossy]

I'm struggling with a syntax problem

If the addition of two cells (a1 and b1) do not add up to more than 10 then I would like cell c1 to display the word FAIL

I've tried the following

If (a1 + b1 ) < 11 then c1 = "FAIL"

But it doesn't like it

Anyone spot what I'm doing wrong

Thanks

[NBVC]

Try putting this formula in C1:

=If(a1 + b1 < 11,"FAIL","PASS")

If you want a blank returned instead of "PASS" then remove the word PASS but leave the quotes..

[Mossy]

Try putting this formula in C1:

=If(a1 + b1 < 11,"FAIL","PASS")

If you want a blank returned instead of "PASS" then remove the word PASS but leave the quotes..

THANKS

That is exactly what I wanted, it was the bits between the ""'s that I was doing wrong

Much appreciated

Cheers

[ChemistB]

Where are you putting the formula? It needs to go into C1.

=IF(A1 + B1<11, "Fail", Something else or a formula or something)

Does that make sense?

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save