Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help Needed (Sum and If Then)
I have a row with 7 Cells each cell will contain a number. The user will
enter a number into each one, but I only want the user to be able to enter a number 0-9 Example: A1=6 A2=5 A3=4 A4=5 A5=8 A6=9 A7=0 After that I have a row with 7 Cells. I need these cells to sort lowest to highest. As far as I can tell it would be the formula be. Example: C1=0 (A7) Formula =SMALL(D4:D10, 1) C2=4 (A3) Formula =SMALL(D4:D10, 2) C3=5 (A2) Formula =SMALL(D4:D10, 3) C4=5 (A5) Formula =SMALL(D4:D10, 4) C5=6 (A1) Formula =SMALL(D4:D10, 5) C6=8 (A5) Formula =SMALL(D4:D10, 6) C7=9 (A6) Formula =SMALL(D4:D10, 7) After that I have a row with 7 cells. I need these cells to take the lowest number and enter it into E1, then take the next highest number and subtract the last lowest number and enter it into the next cell. But if the answer = 0 then enter an X there instead and in red text else change to black text. As far as I can tell part of the formula would be Example: E1=X Red Text Formula = SUM(C1) Not sure how to change to and X or Red Text E2=4 Formula = SUM(C2-C1) Not sure how to change to black Text E3=1 Formula = SUM(C3-C2) Not sure how to change to black Text E4=X Red Text Formula = SUM(C4-C3) Not sure how to change to and X or Red Text E5=1 Formula = SUM(C5-C4) Not sure how to change to black Text E6=2 Formula = SUM(C6-C5) Not sure how to change to black Text E7=1 Formula = SUM(C7-C6) Not sure how to change to black Text Now after that I need If any answer = 1 then change that Cell to red along with the original number that corresponds with it. Else change cell to green. Example: Cell E3 and A2 would be red cells Cell E5 and A1 would be red cells Cell E7 and A6 would be red cells |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help Needed (Sum and If Then)
Only need this to work now:
Now after that I need If any answer = 1 then change that Cell to red along with the original number that corresponds with it. Else change cell to green. Example: Cell E3 and A2 would be red cells Cell E5 and A1 would be red cells Cell E7 and A6 would be red cells |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula help needed | Excel Worksheet Functions | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Formula needed | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions | |||
Formula needed | Excel Programming |