Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difficult IF Function (For me at least) help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difficult IF Function (For me at least) help
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 FormatConditional 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |