If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I add a percentage formula to an IF statement?
I would like to me able to add percentages to an IF formaule allow for a
margin of error, say 10%. If anyone knows a way round it be much obliged. the cell reads "=if(H2=10%, "TRUE", if(h2=h3, "true", if(h210%, "false"))) Thanks Abs |
#2
|
|||
|
|||
Can I add a percentage formula to an IF statement?
Hi Abs
We need something to set the 10% against. Lets say G2 is what you are comparing, and you want a result of true if H2 is within 10% plus or minus of that value. =IF(ABS(H2-G2)/G2=10%,"true","false") -- Regards Roger Govier "Abs" wrote in message ... I would like to me able to add percentages to an IF formaule allow for a margin of error, say 10%. If anyone knows a way round it be much obliged. the cell reads "=if(H2=10%, "TRUE", if(h2=h3, "true", if(h210%, "false"))) Thanks Abs |
#3
|
|||
|
|||
Can I add a percentage formula to an IF statement?
Hi Roger,
Manyt thanks for your help. Thank god there are geniuses like you out there in www :-) Regards Abs "Roger Govier" wrote: Hi Abs We need something to set the 10% against. Lets say G2 is what you are comparing, and you want a result of true if H2 is within 10% plus or minus of that value. =IF(ABS(H2-G2)/G2=10%,"true","false") -- Regards Roger Govier "Abs" wrote in message ... I would like to me able to add percentages to an IF formaule allow for a margin of error, say 10%. If anyone knows a way round it be much obliged. the cell reads "=if(H2=10%, "TRUE", if(h2=h3, "true", if(h210%, "false"))) Thanks Abs |
#4
|
|||
|
|||
Can I add a percentage formula to an IF statement?
Hi Abs
geniuses like you Phewww!!! Steady on there, I'm no genius but there are a few about in these NG's (thank goodness) Thanks for the response and compliment though. -- Regards Roger Govier "Abs" wrote in message ... Hi Roger, Manyt thanks for your help. Thank god there are geniuses like you out there in www :-) Regards Abs "Roger Govier" wrote: Hi Abs We need something to set the 10% against. Lets say G2 is what you are comparing, and you want a result of true if H2 is within 10% plus or minus of that value. =IF(ABS(H2-G2)/G2=10%,"true","false") -- Regards Roger Govier "Abs" wrote in message ... I would like to me able to add percentages to an IF formaule allow for a margin of error, say 10%. If anyone knows a way round it be much obliged. the cell reads "=if(H2=10%, "TRUE", if(h2=h3, "true", if(h210%, "false"))) Thanks Abs |
#5
|
|||
|
|||
Can I add a percentage formula to an IF statement?
=IF(OR(H20.1,H2=H3),TRUE)
"Abs" wrote: I would like to me able to add percentages to an IF formaule allow for a margin of error, say 10%. If anyone knows a way round it be much obliged. the cell reads "=if(H2=10%, "TRUE", if(h2=h3, "true", if(h210%, "false"))) Thanks Abs |
Thread Tools | |
Display Modes | |
|
|