• 0

If Then Else with Text and SUM value


Question

On page: Figures

Value of Cell D1 is 5, Value of Cell D2 is 6.

Cell D3 (on a different page) is:

=IF(Figures.D1>Figures.D2);"It's Bigger by "(Figures.D1-FiguresD2);"It's Smaller by "(Figures.D2-Figures.D1)

 

 

The point being, I want to have a SUM value with Text. Thus, the example above should set Cell D3 as:

It's Smaller by 1

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0

There's actually a cheat code that's been around since the VB days: the &ampersand& :laugh:

=IF(D1<D2,"Its smaller by: " & D2-D1, IF(D1>D2,"Its bigger by: " & D1-D2,"Its equal"))
Link to comment
Share on other sites

  • 0

Man, I hate programming. I just don't have the mind for it.

I have my Football spreadsheet almost done. On page 1, it runs all my

calculations. Then, for simplicity sake, I have a single Column assigned to each week,

with the various stats divided in sections.

 

                Column A[ Team names]      Column B[Offense Score]

ROW1           Dallas                                        14

ROW2           Denver                                      13

ROW3           Washington                               12

 

                     ColumnA[Team names]         Column B[Defense Score]

ROW4            Dallas                                        6

ROW5            Denver                                      7

ROW6            Washington                               8

 

                    Column A[Team name]         Column B[special Team Score]

ROW7            Dallas                                        5

ROW8            Denver                                      6

ROW9            Washington                               7

 

On Page 2, I pit them against each other. I have a drop-down list in Columns A and C

to choose names to pit against each other. Like so:

              COLUMN A    COLUMN B   COLUMN C

ROW1        Dallas                VS           Denver

ROW2      <empty>       ANSWER       <empty>

 

I need to have Cell B2 run a Calculation. For example:

Dallas offense (Page1.B1) - Denver Defense + Special Team (Page1.B5+Page1.B8)

 

Obviously, based on the teams selected.

Link to comment
Share on other sites

  • 0
=IF(D1<D2,CONCATENATE("Its smaller by: ",D2-D1),IF(D1>D2,CONCATENATE("Its bigger by: ",D1-D2),"Its equal"))
amusing its excel you asking about ...

 

Just curious... why amusing? It seems the best tool for the job.

Link to comment
Share on other sites

This topic is now closed to further replies.