Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This formula works too. Thanks all for your help!
xlm wrote: Hi AHizon if you need the formula to only says "OK" when it's equal to each other or when the difference is between 1 and -1, then that formula doesn't take into account of your requirement. if cell A2 = 1 and cell B2 =2 which give you -1, the result is False Unless I have made a wrong assumption, then I apologize try this shorter formula, you need to change the cell's references to yours =IF(OR((A2=B2),AND(A2-B2<=1,A2-B2=-1)),"ok","off by $"&ROUND(A2-B2,0)) HTH Great, that formula did it...Thanks so much! [quoted text clipped - 11 lines] between 1 and -1? Please let me know if there is a way to modify this formula. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200812/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if formula - multi criteria | Excel Worksheet Functions | |||
Sum formula for multiple criteria... help? | Excel Discussion (Misc queries) | |||
Sum If Formula with 3 criteria | Excel Worksheet Functions | |||
multiple criteria formula | Excel Worksheet Functions | |||
2 Criteria Formula | Excel Discussion (Misc queries) |