| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if formula with between value as a criteria
What formula do I use if I'd like to use the if formula but set the criteria
between 2 values? Below is my example. =IF(R29=T29, "OK", IF(R29-T29<1, "OK", "Off by $"&ROUND(R29-T29,0))) If I add a 3rd criteria to display "OK" when it's greater than -1, the formula doesn't calculate right. I'd like the second if statement to be between 1 and -1. Is there any way to modify this existing formula so that it only says "OK" when it's equal to each other or when the difference is 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
