| 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 the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
Try
=AND(D3B3*90%,D3<B3*110%) -- __________________________________ HTH Bob "Mark B" wrote in message ... I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
In cell E3 try the below formula
=ABS(D3-B3)/B3<=0.1 If this post helps click Yes --------------- Jacob Skaria "Mark B" wrote: I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
=AND(D3B3-B3/10, D3<B3+B3/10)
"Jacob Skaria" wrote: In cell E3 try the below formula =ABS(D3-B3)/B3<=0.1 If this post helps click Yes --------------- Jacob Skaria "Mark B" wrote: I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
I like Atishoo one
Now with true and false it should be like tis =IF((AND(D3=B3*90%,D3<=B3*110%)),TRUE,FALSE) "Atishoo" wrote in message ... =AND(D3B3-B3/10, D3<B3+B3/10) "Jacob Skaria" wrote: In cell E3 try the below formula =ABS(D3-B3)/B3<=0.1 If this post helps click Yes --------------- Jacob Skaria "Mark B" wrote: I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
What added value do you think you get with =IF(...TRUE,FALSE) ?
What difference do you get with =IF((AND(D3=B3*90%,D3<=B3*110%)),TRUE,FALSE) compared with =AND(D3=B3*90%,D3<=B3*110%) ? What values does the AND function return? -- David Biddulph "QuickLearner" wrote in message ... I like Atishoo one Now with true and false it should be like tis =IF((AND(D3=B3*90%,D3<=B3*110%)),TRUE,FALSE) "Atishoo" wrote in message ... =AND(D3B3-B3/10, D3<B3+B3/10) "Jacob Skaria" wrote: In cell E3 try the below formula =ABS(D3-B3)/B3<=0.1 If this post helps click Yes --------------- Jacob Skaria "Mark B" wrote: I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
you are right I am an idiot I admit.
My excuse I am learning and thanks for pointing out.. "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... What added value do you think you get with =IF(...TRUE,FALSE) ? What difference do you get with =IF((AND(D3=B3*90%,D3<=B3*110%)),TRUE,FALSE) compared with =AND(D3=B3*90%,D3<=B3*110%) ? What values does the AND function return? -- David Biddulph "QuickLearner" wrote in message ... I like Atishoo one Now with true and false it should be like tis =IF((AND(D3=B3*90%,D3<=B3*110%)),TRUE,FALSE) "Atishoo" wrote in message ... =AND(D3B3-B3/10, D3<B3+B3/10) "Jacob Skaria" wrote: In cell E3 try the below formula =ABS(D3-B3)/B3<=0.1 If this post helps click Yes --------------- Jacob Skaria "Mark B" wrote: I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
Quicklearners formula combining if with and could have an added value of
allowing the user to adapt the output, I know he requested "true or false" but "buy or sell" or "cabbages and cauliflowers" could be more practical outputs for the user! So dont be too hasty to criticise "David Biddulph" wrote: What added value do you think you get with =IF(...TRUE,FALSE) ? What difference do you get with =IF((AND(D3=B3*90%,D3<=B3*110%)),TRUE,FALSE) compared with =AND(D3=B3*90%,D3<=B3*110%) ? What values does the AND function return? -- David Biddulph "QuickLearner" wrote in message ... I like Atishoo one Now with true and false it should be like tis =IF((AND(D3=B3*90%,D3<=B3*110%)),TRUE,FALSE) "Atishoo" wrote in message ... =AND(D3B3-B3/10, D3<B3+B3/10) "Jacob Skaria" wrote: In cell E3 try the below formula =ABS(D3-B3)/B3<=0.1 If this post helps click Yes --------------- Jacob Skaria "Mark B" wrote: I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
Holly Sh.. But you don't realize the simplicity and perfection of Jacob
response??? =ABS(D3-B3)/B3<=0.1 This is the best!! -- Alex *Remember to click "yes" if this post helped you. Thank you! "QuickLearner" wrote: I like Atishoo one Now with true and false it should be like tis =IF((AND(D3=B3*90%,D3<=B3*110%)),TRUE,FALSE) "Atishoo" wrote in message ... =AND(D3B3-B3/10, D3<B3+B3/10) "Jacob Skaria" wrote: In cell E3 try the below formula =ABS(D3-B3)/B3<=0.1 If this post helps click Yes --------------- Jacob Skaria "Mark B" wrote: I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
oops missed that one. Real eye opener .. I just started learning excel so I really did not get that first time.. what I did was using my limited imagination only backed by IF,AND,OR,SUM,AVERAGE you get the idea :) "alexrs2k" wrote in message ... Holly Sh.. But you don't realize the simplicity and perfection of Jacob response??? =ABS(D3-B3)/B3<=0.1 This is the best!! -- Alex *Remember to click "yes" if this post helped you. Thank you! "QuickLearner" wrote: I like Atishoo one Now with true and false it should be like tis =IF((AND(D3=B3*90%,D3<=B3*110%)),TRUE,FALSE) "Atishoo" wrote in message ... =AND(D3B3-B3/10, D3<B3+B3/10) "Jacob Skaria" wrote: In cell E3 try the below formula =ABS(D3-B3)/B3<=0.1 If this post helps click Yes --------------- Jacob Skaria "Mark B" wrote: I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
Usind AND function
=IF((AND((((B3-D3)/B3)*100)<=10,((((B3-D3)/B3)*100)=-10))),TRUE,FALSE) Rachad "Mark B" wrote in message ... I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
What added value do you think you get with =IF(...TRUE,FALSE) ?
What difference do you get with =IF((AND((((B3-D3)/B3)*100)<=10,((((B3-D3)/B3)*100)=-10))),TRUE,FALSE) compared with =(AND((((B3-D3)/B3)*100)<=10,((((B3-D3)/B3)*100)=-10))) or with =AND(((B3-D3)/B3)*100<=10,((B3-D3)/B3)*100=-10) [having deleted a few of the unnecessary parentheses] or with =AND((B3-D3)/B3<=10%,(B3-D3)/B3=-10%) [getting rid of the unnecessary multiplication by 100] ? What values does the AND function return? Doesn't it return the Boolean TRUE and FALSE ? -- David Biddulph "QuickLearner" wrote in message ... Usind AND function =IF((AND((((B3-D3)/B3)*100)<=10,((((B3-D3)/B3)*100)=-10))),TRUE,FALSE) Rachad "Mark B" wrote in message ... I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is Cell D3 within 10% of B3 True or false?
The question does say "within 10%" not within or equal to!
"Mark B" wrote: I have two Columns of Data, I want to know if the Data in column D is within 10% + or - of the data in column B e.g Is Cell D3 within 10% of B3 True or false? Should be simple but I can't figure it out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Excel Yes / No, True / False etc. cell selection buttons? | Excel Worksheet Functions | |||
| 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
