Sign in to follow this  

If Then Else with Text and SUM value

Recommended Posts

McCordRm    413
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 this post


Link to post
Share on other sites
Torolol    925
=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 ...

Share this post


Link to post
Share on other sites
McCordRm    413

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

Worked like a champ, though. THANKS!

Share this post


Link to post
Share on other sites
GreenMartian    90

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 this post


Link to post
Share on other sites
McCordRm    413

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.

Share this post


Link to post
Share on other sites
McCordRm    413
=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.

Share this post


Link to post
Share on other sites
streetw0lf    202

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

Share this post


Link to post
Share on other sites
McCordRm    413

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.