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
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