Difficult IF Function (For me at least) help

[pete321]

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

[Biff]

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

"pete321" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> pete321
> ------------------------------------------------------------------------
> pete321's Profile:
> http://www.excelforum.com/member.php...o&userid=35354
> View this thread: http://www.excelforum.com/showthread...hreadid=552098
>