Jump to content



Photo

If Then Else with Text and SUM value

Answered Go to the full post excel

  • Please log in to reply
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"))
amusing its excel you asking about ...

#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
  • Location: adelaide, au

Posted 18 September 2013 - 10:11

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


#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

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.



#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"))
amusing its excel you asking about ...

 

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.





Click here to login or here to register to remove this ad, it's free!