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 |
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) |