determine formula for percentage
formula in B39:
=SUM(B11:B37)
in B40:
=B39*15%
In B41:
=B40+B39
Cell B40 may initially spit out a number with multiple integers, simply
format to collar. If you need to avoid the possibility of lost decimals,
formula in B40 could be changed to:
=ROUND(B39*15%,2)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Shannon" wrote:
I am adding B11 through B37, the subtotal appears in B39. In B40 I want to
display 15% of B39. Then in B41, B40 will be added for a grand total. These
figures are $amounts. I need to know the formula I would use in B39
|