Help with Formula

[Dave G]

Hi all

I have been trying to write a formula using the IF function and the SQRT
function, yet can't get the syntax right.

In E1 there is a number in E2 I'd like to put a formula, If the square root
of E1 is at least 17 the result will be a pass otherwise it will be a fail.

I had thought I'd got it right many times, yet it was always wrong, my cells
are formatted to general.

Any help appreciated

Can anyone point me to a site that explains the syntax of writing Excel
formulas, where to put the comma's, brackets etc.

Thanks.

Dave

 

[Guest]

The formula is:

=if(sqrt(E1)>=18,"PASS","FAIL")

If you aren't certain about the setup of the formula use the equals button
next to the formula bar and it will provide you with assistance in completing
the formula and will insert the commas at the right place.

Ian

 

[Pete_UK]

Try this in E2:

=IF(SQRT(E1)>=17,"Pass","Fail")

Hope this helps.

Pete