Formula Help Needed (Sum and If Then)


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: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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top