Help with Formula


D

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
 
Ad

Advertisements

G

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top