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 ot...
  • Lorenzo Kim's avatar
    Oct 16, 2018
    A2=1410 B2=1410
    formula for C2:
    =((A2+B2)*1.04)*0.05
    HTH

Resources