Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having a few problems If functions and using 'or'
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having a few problems If functions and using 'or'
=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 -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=560601 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having a few problems If functions and using 'or'
=IF(O18*110%<MAX(H18:N18),"Look","OK")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "davidrostron" wrote in message news:davidrostron.2att0d_1152696904.3559@excelforu m-nospam.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|