Prev: How to merge 2 + contiguous cells without lossing data?
Next: Pivot Table
From: Vicki on 4 Jun 2010 12:34
Please help!

I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.

I am using the below formula.

=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)>ABS(20),((C30-$G30)/$G30)," "))

Thanks
From: Tom Hutchins on 4 Jun 2010 14:40
The value of 20% is 0.2 not 20. Change ABS(20) to ABS(.2)

Hope this helps,

Hutch

"Vicki" wrote:

> Please help!
>
> I am trying to get the formula below to return a value to the cell ONLY if
> the answer to ((c30-$30)/g$30) is greater or less than 20%.
>
> I am using the below formula.
>
> =IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)>ABS(20),((C30-$G30)/$G30)," "))
>
> Thanks
From: Vicki on 4 Jun 2010 15:13
Thanks Tom!

Just discovered that myself.

Amazing what that silly little decimal point will do. Hahaha


"Tom Hutchins" wrote:

> The value of 20% is 0.2 not 20. Change ABS(20) to ABS(.2)
>
> Hope this helps,
>
> Hutch
>
> "Vicki" wrote:
>
> > Please help!
> >
> > I am trying to get the formula below to return a value to the cell ONLY if
> > the answer to ((c30-$30)/g$30) is greater or less than 20%.
> >
> > I am using the below formula.
> >
> > =IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)>ABS(20),((C30-$G30)/$G30)," "))
> >
> > Thanks
 | 
Pages: 1
Prev: How to merge 2 + contiguous cells without lossing data?
Next: Pivot Table