Can someone please help me with an excel formula I can't figure out?

[Shannon Sterling]

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.  

[#2 · Accepted solution]

A2=1410 B2=1410
formula for C2:
=((A2+B2)*1.04)*0.05
HTH

[#3]

Life saver!  Thanks so much!!!!

[#4]

glad it helped...