Having a few problems If functions and using 'or'

[davidrostron]

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?

 

[robert111]

=if(or(o18<n18*1.1,o18<m18*1.1,o18<l18*1.1)=1,"yes","no")

this does it for 3 columns, you can have up to 30 in there

 

[Bob Phillips]

=IF(O18*110%<MAX(H18:N18),"Look","OK")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"davidrostron" <[email protected]>
wrote in message
news:[email protected]...