View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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