Plus or Minus
 

Is there a function or a way to tell excel to return a specific string
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.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=560158

Plus or Minus
 

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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=560158

Plus or Minus
 

Thanks Dav, worked great.

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


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=560158