I'm trying to set up a spreadsheet to compare some prices at work. I
have 7 columns of prices which i have averaged out in a further column.
What i'd like to do is cross check the prices with the average using an
if function to highlight if any of the prices columns are above 10% of
the average price. And i'm bloody stuck!!! I can use the correct
formula for one of the price colums but i'd like to check all the other
price colums and i assume i should be using the 'or' function but i
don't have any idea how to work it. Any help would be greatly
appreciated!

This is the formula i've used for cross checking one of my colums:
=IF(O18<N18*1.1,"Look","OK")

How do i adapt this to incorporate columns H,I,J,K... etc?


--
davidrostron
------------------------------------------------------------------------
davidrostron's Profile: http://www.excelforum.com/member.php...o&userid=36281
View this thread: http://www.excelforum.com/showthread...hreadid=560601