software

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
The formula is:

=if(sqrt(E1)gt;=18,quot;PASSquot;,quot;FAILquot;)

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

quot;Dave Gquot; wrote:

gt; Hi all
gt;
gt; I have been trying to write a formula using the IF function and the SQRT
gt; function, yet can't get the syntax right.
gt;
gt; In E1 there is a number in E2 I'd like to put a formula, If the square root
gt; of E1 is at least 17 the result will be a pass otherwise it will be a fail.
gt;
gt; I had thought I'd got it right many times, yet it was always wrong, my cells
gt; are formatted to general.
gt;
gt; Any help appreciated
gt;
gt; Can anyone point me to a site that explains the syntax of writing Excel
gt; formulas, where to put the comma's, brackets etc.
gt;
gt; Thanks.
gt;
gt; Dave
gt;
gt;
gt;

Try this in E2:

=IF(SQRT(E1)gt;=17,quot;Passquot;,quot;Failquot;)

Hope this helps.

Pete