Forum Discussion

Shannon Sterling's avatar
Shannon Sterling
Copper Contributor
Oct 16, 2018
Solved

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.  

 

 

Resources