Welcome Guest! To access all forums & features, please register an account or sign-in. → Why register?

# If Then Else with Text and SUM value

Answered Go to the full post excel

7 replies to this topic

### #1 +McCordRm

McCordRm

http://richardmccord.com

• Tech Issues Solved: 1
• Joined: 06-July 06
• Location: Dallas, TX

Posted 18 September 2013 - 04:43

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

Best Answer +McCordRm , 18 September 2013 - 04:52

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

Worked like a champ, though. THANKS!

Go to the full post

### #2 Torolol

Torolol

• Joined: 24-November 12

Posted 18 September 2013 - 04:47

`=IF(D1<D2,CONCATENATE("Its smaller by: ",D2-D1),IF(D1>D2,CONCATENATE("Its bigger by: ",D1-D2),"Its equal"))`

### #3 OP +McCordRm

McCordRm

http://richardmccord.com

• Tech Issues Solved: 1
• Joined: 06-July 06
• Location: Dallas, TX

Posted 18 September 2013 - 04:52   Best Answer

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

Worked like a champ, though. THANKS!

### #4 +GreenMartian

GreenMartian

Neowinian Senior

• Joined: 28-August 04

Posted 18 September 2013 - 10:11

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

```=IF(D1<D2,"Its smaller by: " & D2-D1, IF(D1>D2,"Its bigger by: " & D1-D2,"Its equal"))
```

### #5 OP +McCordRm

McCordRm

http://richardmccord.com

• Tech Issues Solved: 1
• Joined: 06-July 06
• Location: Dallas, TX

Posted 20 September 2013 - 22:08

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.

### #6 OP +McCordRm

McCordRm

http://richardmccord.com

• Tech Issues Solved: 1
• Joined: 06-July 06
• Location: Dallas, TX

Posted 20 September 2013 - 22:13

`=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.

### #7 streetw0lf

streetw0lf

Neowinian³

• Joined: 03-January 04
• Location: USA

Posted 20 September 2013 - 22:37

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

### #8 OP +McCordRm

McCordRm

http://richardmccord.com

• Tech Issues Solved: 1
• Joined: 06-July 06
• Location: Dallas, TX

Posted 21 September 2013 - 01:49

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