Results 1 to 3 of 3

Thread: Need a multiple formula which can bring result in single cell

  1. #1

    Need a multiple formula which can bring result in single cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Friends/Experts,

    I need a multipurpose formula (add /subtract/multiply/percentage) which can bring the result in the same cell. I would like to elaborate below for clear understating.

    Ex: 25 X 35= 875 X 5%= 918 (875 + 44 which is 5% on 875) + 350 = 1268 (875+44+350) etc… Final amount is = 1268.

    As we all know that we can fetch the above result if the figures are in different columns but I need the same in single cell, the way we compute in calculator, Hence, I request you all kindly help me if we can do the same by using any conditional formula.

    You support in this regard would be appreciated.

    Thanks in advance

  2. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    well it looks like you have some rounding issues in your above example.
    however you can accomplish this with 1 formula.
    =25*35*1.05+350
    this computes to 1268.75

  3. #3
    Hi Thanks a lot for the reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •