Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dealing with minus numbers in formulas | Excel Discussion (Misc queries) | |||
Equivalent of Minus in Excel. Also Union, Intersect. | Excel Worksheet Functions | |||
converting minus quantities to plus | New Users to Excel | |||
strip minus signs from right to left | Excel Discussion (Misc queries) | |||
minus formel/fortegn | Excel Discussion (Misc queries) |