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

1. Need a multiple formula which can bring result in single cell

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.

2. 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. 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
•