Forum Discussion
Shannon Sterling
Oct 16, 2018Copper Contributor
Can someone please help me with an excel formula I can't figure out?
I have two cells, that I need to add together ($2820) and find 4% ($112.80) of those. And then I need to take that total ($2820 + $112.80) and get 5% of that.
So say one cell is $1410 and the other cell is $1410
My third cell (for the formula) needs to show:
($2820+112.80) x .05 = $146.64
The $146.64 is the number I need to come up with - and can do it manually - just not sure how to do it all in one cell - or if it's even possible.
- A2=1410 B2=1410
formula for C2:
=((A2+B2)*1.04)*0.05
HTH
3 Replies
- Lorenzo KimBronze ContributorA2=1410 B2=1410
formula for C2:
=((A2+B2)*1.04)*0.05
HTH- Shannon SterlingCopper Contributor
Life saver! Thanks so much!!!!
- Lorenzo KimBronze Contributorglad it helped...