Jump to content

8 posts in this topic

Posted

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

Posted

=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

Posted

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

Posted

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

Posted

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

Posted

=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

Posted

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

Posted

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  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.