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 ot...
- Oct 16, 2018A2=1410 B2=1410
formula for C2:
=((A2+B2)*1.04)*0.05
HTH
Lorenzo Kim
Oct 16, 2018Bronze Contributor
A2=1410 B2=1410
formula for C2:
=((A2+B2)*1.04)*0.05
HTH
formula for C2:
=((A2+B2)*1.04)*0.05
HTH
- Shannon SterlingOct 17, 2018Copper Contributor
Life saver! Thanks so much!!!!
- Lorenzo KimOct 17, 2018Bronze Contributorglad it helped...