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 