Difficult IF Function (For me at least) help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pete321 - 15 Jun 2006 02:23 GMT

hi, I've been playing with an if function i just cant figure out for
about close to an hour, i figure it will be much faster just asking
someone experienced.

I have three columns. A, B, C lets say

Each have many rows of data in them

the function im trying to do is, "if the Sum of Column A is between 25
and 35% of the sum of columns A, B and C make the cell Green, if not,
make it red?

another easier question that i need is "If sum of column D is between
470 and 530 make cell green color, if not, make red"

if the color thing is too hard to do, ill just make it say true false
or whatever, just would be more aesthically pleasing if it was red or
green. The main thing is the formula

thanks in advance

Signature

pete321

Reply to this Message

Biff - 15 Jun 2006 02:59 GMT

Hi!

> the function im trying to do is, "if the Sum of Column A is between 25
> and 35% of the sum of columns A, B and C make the cell Green, if not,
> make it red?

Adjust the ranges in the below formulas to meet your needs.

Select the cell you want to color
Goto Format>Conditional Formatting
Condition 1
Formula Is:
=AND(SUM(A1:A10)/SUM(A1:C10)>=0.25,SUM(A1:A10)/SUM(A1:C10)<=0.35)
Click the format button
Select a GREEN fill pattern
OK
Clcick Add
Condition 2
Formula Is:
=--AND(SUM(A1:A10)/SUM(A1:C10)>=0.25,SUM(A1:A10)/SUM(A1:C10)<=0.35)=0
Click the Format button
Select a RED fill pattern
OK out.

> another easier question that i need is "If sum of column D is between
> 470 and 530 make cell green color, if not, make red"

After doing it for the above you should be able to figure this one out!

Biff

> hi, I've been playing with an if function i just cant figure out for
> about close to an hour, i figure it will be much faster just asking
[quoted text clipped - 16 lines]
>
> thanks in advance

Reply to this Message