LinkBack URL
About LinkBacks
Hi,
How about these, presuming actual and forecast are in columns A and B.
=ABS((A1-B1)/A1)<=0.05
=AND(ABS((A1-B1)/A1)>0.05,ABS((A1-B1)/A1)<=0.1)
=ABS((A1-B1)/A1)>0.1
Hi,
How about these, presuming actual and forecast are in columns A and B.
=ABS((A1-B1)/A1)<=0.05
=AND(ABS((A1-B1)/A1)>0.05,ABS((A1-B1)/A1)<=0.1)
=ABS((A1-B1)/A1)>0.1
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks