Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement value range required
I'm attempting to create an IF statement that returns a value of
satisfactory if the tolerance result is off by less then 1%. My problem is that the possibility exists for both positive and negative numbers. Thus, a tolerance result of -5% still comes back as satisfactory because it is less then 1. I need to define a range and I do not know how. At present, my formula looks like this. Any advice would be appreciated. =IF(I29<=1,"SAT",IF(I29<=-1,"SAT",IF(I29="","","UNSAT"))) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement value range required
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement value range required
Sir, you are a godsend. Thank you much.
It has been literally years since I've done anything like this and I must say I am enjoying wading through all of these formulas, tools and all around options. What a great resource these groups are! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
range in an IF statement | Excel Worksheet Functions | |||
if statement with a range without a cell reference ie, #s 1100 to | Excel Worksheet Functions | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Using a worksheet name from a range | Excel Worksheet Functions | |||
If statement where the logical test is a range that equals a word | Excel Worksheet Functions |