| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Express a Formula that is + or - 20% from a Value Q
How can I express a formula that checks to see if a value is within +
or - 20% from another value? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Express a Formula that is + or - 20% from a Value Q
Try this:
=IF(ABS((B1-A1)/A1)<=0.2,"OK","Out of tolerance") Hope this helps. Pete On Jan 14, 10:40*am, Sean wrote: How can I express a formula that checks to see if a value is within + or - 20% from another value? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Express a Formula that is + or - 20% from a Value Q
Thanks Pete, just figured it out using ABS
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Express a Formula that is + or - 20% from a Value Q
You're welcome, Sean.
Pete On Jan 14, 11:13*am, Sean wrote: Thanks Pete, just figured it out using ABS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| out express | Setting up and Configuration of Excel | |||
| can I express X*4 in a formula? | Excel Discussion (Misc queries) | |||
| A formula to express distance per minute .... | Excel Discussion (Misc queries) | |||
| How to express this in an if statement. | Excel Worksheet Functions | |||
| How to express $A:$A with formula | Excel Worksheet Functions | |||
Linear Mode
