Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
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 "Dave G" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
Try this in E2:
=IF(SQRT(E1)=17,"Pass","Fail") Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |