• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 69
  • Last Modified:

I need an excel formula

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.
  • 2
2 Solutions
Wayne Taylor (webtubbs)Commented:
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.
Wayne Taylor (webtubbs)Commented:
Taking it a step further to eliminate the SUM cells....

    =TEXT(DATA!B3+DATA!D3, "$#,###") &  " (E)" & CHAR(10) & TEXT(DATA!C3+DATA!E3, "$#,###") & " (A)"
wrt1meaAuthor Commented:
So sorry Wayne!!!!!!!!!!!!!!

I have been out and really thought I awarded points

Great answer!!!!!!!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now