Solved

I need an excel formula

Posted on 2014-12-16
3
57 Views
Last Modified: 2015-01-08
I am looking for an excel formula to add two columns together then place an (E) after it, then add two different columns and place an (A) after that number in the same cell.

I have attached an example. I would like it to come out exactly the way the example is, with formatting, etc...yellow is not necessary.
C--Users-twynn-Desktop-ExExch-12-16-14.x
0
Comment
Question by:wrt1mea
  • 2
3 Comments
 
LVL 47

Assisted Solution

by:Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs) earned 500 total points
ID: 40503440
Try this formula...

    =TEXT(D3, "$#,###") &  " (E)" & CHAR(10) & TEXT(E3, "$#,###") & " (A)"

You'll need to ensure "Wrap Text" is turned on for the cell this formula is in.
0
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 500 total points
ID: 40503539
Taking it a step further to eliminate the SUM cells....

    =TEXT(DATA!B3+DATA!D3, "$#,###") &  " (E)" & CHAR(10) & TEXT(DATA!C3+DATA!E3, "$#,###") & " (A)"
0
 
LVL 1

Author Closing Comment

by:wrt1mea
ID: 40538934
So sorry Wayne!!!!!!!!!!!!!!

I have been out and really thought I awarded points

Great answer!!!!!!!!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now