Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if cell A is +- 10% of cell B
Hi
What is the best way to write if statement to show if cell A1 is 10% greater or 10%smaller than cell B1 thanks Pat |
#2
|
|||
|
|||
Hi Tina
=IF(OR(A1B1*(1+10%),A1<B1*(1-10%)),"Yes","No") Note this excludes equal to +10% and -10% values themselves. Change to = to include these values. Regards Roger Govier tina wrote: Hi What is the best way to write if statement to show if cell A1 is 10% greater or 10%smaller than cell B1 thanks Pat |
#3
|
|||
|
|||
Roger,
I believe the phrasing in Tina's request contains an OR, but what she really means is =IF(AND(A1<B1*(1+10%),A1B1*(1-10%)),"Yes","No") HTH Kostis Vezerides |
#4
|
|||
|
|||
Hi Kostis
Maybe. The OP now has both solutions and can decide which suits her requirements. Regards Roger Govier vezerid wrote: Roger, I believe the phrasing in Tina's request contains an OR, but what she really means is =IF(AND(A1<B1*(1+10%),A1B1*(1-10%)),"Yes","No") HTH Kostis Vezerides |
#5
|
|||
|
|||
Thank you Roger
I did mean "or" as trying to find out if a difference between 2 numbers is greater than 10% Thank you Kostis for your time Tina "Roger Govier" wrote: Hi Kostis Maybe. The OP now has both solutions and can decide which suits her requirements. Regards Roger Govier vezerid wrote: Roger, I believe the phrasing in Tina's request contains an OR, but what she really means is =IF(AND(A1<B1*(1+10%),A1B1*(1-10%)),"Yes","No") HTH Kostis Vezerides |
#6
|
|||
|
|||
Hi Tina
Thanks for the feedback. Seeing your request expressed that way, you could use the shorter =ABS(B1-A1)/B1=10% which will return TRUE or FALSE. Regards Roger Govier tina wrote: Thank you Roger I did mean "or" as trying to find out if a difference between 2 numbers is greater than 10% Thank you Kostis for your time Tina "Roger Govier" wrote: Hi Kostis Maybe. The OP now has both solutions and can decide which suits her requirements. Regards Roger Govier vezerid wrote: Roger, I believe the phrasing in Tina's request contains an OR, but what she really means is =IF(AND(A1<B1*(1+10%),A1B1*(1-10%)),"Yes","No") HTH Kostis Vezerides |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
if cell A is +- 10% of cell B
this formula works great --- however, what if I want the yes to turn red and
the no to turn green what do I do? Thanks! "Roger Govier" wrote: Hi Tina =IF(OR(A1B1*(1+10%),A1<B1*(1-10%)),"Yes","No") Note this excludes equal to +10% and -10% values themselves. Change to = to include these values. Regards Roger Govier tina wrote: Hi What is the best way to write if statement to show if cell A1 is 10% greater or 10%smaller than cell B1 thanks Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |