Thread: Plus or Minus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwardpestian edwardpestian is offline
external usenet poster
 
Posts: 1
Default 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