Thanks Michael!!!!
"Michael" wrote:
Hi JJ
Try this for more than or less than 5%
=IF(D2(C2*1.05),"Flag",IF(D2<(C2*0.95),"Flag","") )
Change the "Flag" text to suit yourself.
HTH
Michael
"jj" wrote:
I'm struggling to create an exception report.
I need to flag an empty cell if the adjacent cell varies more than 5% of
another cell.
Example:
C2 is $100
D2 is $300
I need E2 to post a * indicating D2 is more than 5% of C2
Any help would be appreciated.
|