LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
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 100000<149999 recieve 0.5% commission
if house sold for 150000<199999 recieve 1.0% commission
if house sold for 200000 recieve 1.5% commission
bonus $2000 if total sales 10000
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif? array enter? Jack Sons Excel Discussion (Misc queries) 14 July 13th 09 05:34 PM
SUMIF - how to enter a second criteria Count1314 Excel Discussion (Misc queries) 1 June 20th 09 11:39 AM
Macro to select cells in column enter data then press enter NP New Users to Excel 1 February 20th 08 04:21 PM
enter doesn't work with sumif Infrascanner Excel Worksheet Functions 1 January 27th 06 04:32 PM
Multiple Criteria Sumif/Sum..tried & failed Ctrl+Shift+Enter, chris100 Excel Discussion (Misc queries) 2 July 13th 05 10:58 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"