IF Function

[sgrech]

Here is a nice easy one!

I have a value in a spreadsheet that I need to check. If the valu
<-0.005% or >0.005%, then I need to notify the user that an adjustmen
is required.

I tried this

=IF(C27<-0.0049999,"adj required",(IF(C27>0.0049999,"adj required","n
adj required")))

but alas it doesn't work. Can anyone help?

Thanks
Simo

 

[Domenic]

Try...

=IF(A1<>"",IF(ABS(A1)>0.005%,"Adjustment Required","No Adjustmen
Required"),"")

Hope this helps!

 

[Bob Sweet]

Have you tried using "Validation" under the Data menu?