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
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
=IF(ABS(B1/A1-1)>0.03,TRUE,FALSE)
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
You don't need the if statement:
=(ABS(B1/A1-1)>0.03)
will work fine
Hi Guys,
Both work fine - thanks again for your help
regards
Jon