View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DestinySky DestinySky is offline
external usenet poster
 
Posts: 16
Default Deducting from a total!! HELP!!!!!!!!!!!!!

I have a spreadsheet with 8 rows and 6 columns. At the end of each row is a
dollar amount. I will need the cells in each row to deduct from that rows
dollar amount.
EX.
Customer week 1 week 2
week3 total
ABC Customer $500.00 $300.00 $600.00
15000.00

what formula would I need to use to deduct the 500.00, 300.00 and 600.00
from the 15000.00??

THANKS !!!!