How to add Sum of multiple Formula

[Nitin Shardul]

=250000*2.915/1000*(1-80/100)+(250000*(0.1125+0.11)/1000)
Sum 250000
Rate 2.915/1000
Discount 80%
Rate on 250000 (0.1125+0.11)/1000

Gross Amount comes to 201.375
Want to Add 14.5% Service Tax Result will be 230.574

Thanks,

Nitin

 

[Khalid NGO]

Hi Nitin,
Can you post a sample file?

General answer would be:
(Result) x percentage + Result

=(250000*2.915/1000*(1-80/100)+(250000*(0.1125+0.11)/1000))*14.5%+250000*2.915/1000*(1-80/100)+(250000*(0.1125+0.11)/1000)

Regards,

 

[Nitin Shardul]

Thanks for the quick response
Please find attached sample file

 

[Khalid NGO]

Here you go:
=(B5*2.915/1000*(1-80/100)+(B5*(0.12375+0.11+0.165)/1000))*14.5%+B5*2.915/1000*(1-80/100)+(B5*(0.12375+0.11+0.165)/1000)

I have not tested your complete formula.
Regards,

 

[Nitin Shardul]

It Works
Thanks a Lot

 

[John Jairo V]

Hi @Khalid NGO (and @Nitin Shardul)

Result * percentage + Result can be shortened to:

Result(1 + percentaje) with common factor (basics of algebra factoring). Then, your formula could be:

=(B5*2.915/1000*(1-80%)+(B5*(0.12375+0.11+0.165)/1000))*(1 + 14.5%)

Blessings!

 

[Khalid NGO]

Result(1 + percentaje)

Hi JJV,
Awesome & Simple.

Thank you.