Hi
I'm creating a workflow management spreadsheet which shows volumes received, cleared etc.
I also want to compare the volume received against the average received over the past 5 weeks. I have 5 columns for the previous weeks data and a colume to calculate the average.
I then have another column to compare the average to what was received this week. The column will contain a series of arrows to show if the volume received is above, below or the same as the average, the forumla I've used is:-
=IF(D8=K8,"è",IF(D8<K8,"ê","é"))
D8 = Volume received this week
K8 = Average of previous 5 weeks - =AVERAGE(L8:P8)
the different "e"s appear as arrows in the Windings font.
The problem I have is that the average for the past 5 weeks is 133.8, but i'm not showing any decimal places so excel rounds it up to 134.
The received volume for this week is 134, so the arrow should show the volumes are the same BUT an up arrows is appearing because the actual average is 133.8 not 134.
Is there a change I can make so excel will recognise these as the same??
Bookmarks