Solved

I need an excel formula

Posted on 2014-12-16
3
59 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

816 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

9 Experts available now in Live!

Get 1:1 Help Now