Plus or Minus

[edwardpestian]

Is there a function or a way to tell excel to return a specific strin
if a value is say plus or minus 5.

For example:

IF(OR(K9=K35,K9=""),"ESTIMATE","ACTUALS")

I need it to say if K9 is equal to K35 plus or minus 5.

Thanks.

e

 

[Dav]

=IF(ABS(k9-k35)<5,true response,false response)

Regards

Da

 

[edwardpestian]

Thanks Dav, worked great.

IF(OR(ABS(K9-K35)<5,K35=""),"ESTIMATE","ACTUALS"