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(h2>10%, "false")))

Thanks
Abs

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" <(E-Mail Removed)> wrote in message
news:A6680261-186E-4AAF-BC2C-(E-Mail Removed)...
>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(h2>10%,
> "false")))
>
> Thanks
> Abs

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" <(E-Mail Removed)> wrote in message
> news:A6680261-186E-4AAF-BC2C-(E-Mail Removed)...
> >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(h2>10%,
> > "false")))
> >
> > Thanks
> > Abs
>
>
>

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" <(E-Mail Removed)> wrote in message
news:912B5826-3A65-4875-9C36-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:A6680261-186E-4AAF-BC2C-(E-Mail Removed)...
>> >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(h2>10%,
>> > "false")))
>> >
>> > Thanks
>> > Abs
>>
>>
>>

=IF(OR(H2<0.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(h2>10%, "false")))
>
> Thanks
> Abs