View Single Post
  #1  
Old May 14th, 2010, 10:47 AM posted to microsoft.public.excel.newusers
KiKi
external usenet poster
 
Posts: 20
Default how do I enter this in excel sumif

enter formulas to calulate the total for each sale and the amount of
commission earned by each sale using the following information:
House sold for 138000
House sold for 200000
if house sold for 100000149999 recieve 0.5% commission
if house sold for 150000199999 recieve 1.0% commission
if house sold for 200000 recieve 1.5% commission
bonus $2000 if total sales 10000