A
Albert Mulder
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
10, 1)
C2=4 (A3) Formula =SMALL(D410, 2)
C3=5 (A2) Formula =SMALL(D410, 3)
C4=5 (A5) Formula =SMALL(D410, 4)
C5=6 (A1) Formula =SMALL(D410, 5)
C6=8 (A5) Formula =SMALL(D410, 6)
C7=9 (A6) Formula =SMALL(D410, 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
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
10, 1)C2=4 (A3) Formula =SMALL(D4
10, 2)C3=5 (A2) Formula =SMALL(D4
10, 3)C4=5 (A5) Formula =SMALL(D4
10, 4)C5=6 (A1) Formula =SMALL(D4
10, 5)C6=8 (A5) Formula =SMALL(D4
10, 6)C7=9 (A6) Formula =SMALL(D4
10, 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