PDA

View Full Version : [SOLVED] Help with formula please



blackie42
08-27-2017, 01:36 AM
Hi

I need to compare a cell value to the adjacent cell to see if the differ by more than 3% (up or down)

Tried a logical test but can't get it to work.

Any help as always very much appreciated

thanks
Jon

mdmackillop
08-27-2017, 02:41 AM
=IF(ABS(B1/A1-1)>0.03,TRUE,FALSE)

offthelip
08-27-2017, 04:40 AM
You don't need the if statement:

=(ABS(B1/A1-1)>0.03)

will work fine

blackie42
08-27-2017, 05:08 AM
Hi Guys,

Both work fine - thanks again for your help

regards
Jon