Followers 0

# If Then Else with Text and SUM value

## 8 posts in this topic

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

##### Share on other sites
`=IF(D1<D2,CONCATENATE("Its smaller by: ",D2-D1),IF(D1>D2,CONCATENATE("Its bigger by: ",D1-D2),"Its equal"))`

##### Share on other sites

There's a command I'm not familiar with.

Worked like a champ, though. THANKS!

##### Share on other sites

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"))
```

##### Share on other sites

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

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.

##### Share on other sites
`=IF(D1<D2,CONCATENATE("Its smaller by: ",D2-D1),IF(D1>D2,CONCATENATE("Its bigger by: ",D1-D2),"Its equal"))`

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

##### Share on other sites

Probably because one doesn't usually consider Excel a programming language in the traditional sense, that's all.

##### Share on other sites

AH.... I didn't have the Software thread in my favs, so I didn't see it. I'll repost there.

## Create an account

Register a new account