| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is Cell D3 within 10% of B3 True or false?
I have two columns of data.
I want to know if one column is within 10% of the second column. E.g. Is Cell D3 within 10% + or - of B3? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
=if(and(d3=90%*b3,d3<=110%*b3),TRUE,FALSE)
Andrea Jones www.allaboutclait.com "Mark B" wrote: I have two columns of data. I want to know if one column is within 10% of the second column. E.g. Is Cell D3 within 10% + or - of B3? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
In what way does
=if(and(d3=90%*b3,d3<=110%*b3),TRUE,FALSE) have an advantage over =and(d3=90%*b3,d3<=110%*b3) ? Doesn't the AND function return a Boolean TRUE or FALSE result? -- David Biddulph "Andrea Jones" wrote in message ... =if(and(d3=90%*b3,d3<=110%*b3),TRUE,FALSE) Andrea Jones www.allaboutclait.com "Mark B" wrote: I have two columns of data. I want to know if one column is within 10% of the second column. E.g. Is Cell D3 within 10% + or - of B3? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
Check your previous post..
In cell E1; (for boolean values) =ABS(D3-B3)/B3<=0.1 In cell E1; (for text) =IF(ABS(D3-B3)/B3<=0.1,"True","False") If this post helps click Yes --------------- Jacob Skaria "Mark B" wrote: I have two columns of data. I want to know if one column is within 10% of the second column. E.g. Is Cell D3 within 10% + or - of B3? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
Hi,
This returns TRUE/False =ABS(B3-D3)/D3<=0.1 or to return text confirmation =IF(ABS(B3-D3)/D3<=0.1,"Within 10%","More than 10%") Mike "Mark B" wrote: I have two columns of data. I want to know if one column is within 10% of the second column. E.g. Is Cell D3 within 10% + or - of B3? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
Hello All,
I think Mike H's answer below is the best fit. I did eventually figure out the following which also seems to work: =IF(ABS(X14)(V14*1.1),"x","") Puts an X in the column if it is greater than V14+10% Does anyone have a preference for one solution over the other? "Mike H" wrote: Hi, This returns TRUE/False =ABS(B3-D3)/D3<=0.1 or to return text confirmation =IF(ABS(B3-D3)/D3<=0.1,"Within 10%","More than 10%") Mike "Mark B" wrote: I have two columns of data. I want to know if one column is within 10% of the second column. E.g. Is Cell D3 within 10% + or - of B3? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
Something wrong with our last set of replies?
-- __________________________________ HTH Bob "Mark B" wrote in message ... I have two columns of data. I want to know if one column is within 10% of the second column. E.g. Is Cell D3 within 10% + or - of B3? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is Cell D3 within 10% of B3 True or false? | Excel Discussion (Misc queries) | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Use IF to change value in a different cell when TRUE (or FALSE)? | Excel Discussion (Misc queries) | |||
Hybrid Mode
