Need a multiple formula which can bring result in single cell

kumar

New member
Joined
Dec 17, 2013
Messages
11
Reaction score
0
Points
0
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
 

Simi

New member
Joined
Feb 10, 2012
Messages
190
Reaction score
0
Points
0
Location
Utah, USA
Excel Version(s)
Version 2002 Build 12527.20194
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
 
Top