Help with formula please

[blackie42]

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]

=IF(ABS(B1/A1-1)>0.03,TRUE,FALSE)

[offthelip]

You don't need the if statement:

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

will work fine

[blackie42]

Hi Guys,

Both work fine - thanks again for your help

regards
Jon