Solved

# I need an excel formula

Posted on 2014-12-16
61 Views
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
Question by:wrt1mea
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 47

Assisted Solution

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

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

ID: 40538934
So sorry Wayne!!!!!!!!!!!!!!

I have been out and really thought I awarded points

0

## Featured Post

Question has a verified solution.

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

### Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …