Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula help needed Karen Excel Worksheet Functions 7 February 2nd 10 01:09 AM
Excel formula to copy/paste formula needed please. colwyn Excel Discussion (Misc queries) 4 October 22nd 08 11:27 PM
Formula needed Connie Martin Excel Worksheet Functions 10 May 4th 06 01:19 AM
Formula needed Edgar Thoemmes Excel Worksheet Functions 3 January 13th 05 02:07 PM
Formula needed JUAN Excel Programming 7 May 28th 04 07:37 PM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"