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: 5
Default conditional statement; is that what i need to use?

MS Excel 2003

The spreadsheet is for determining the cost for books from a publisher. The
books are priced at a base price plus a price based on the number of
signatures. Pages added in bundles of 12 and these bundles are called
signatures. With 10 signatures or less the price is the base price + $5 per
signature. For more than 10 signatures, the price is base price + $20 per
signature. (The base price of the book already has one signature)

Where C2 is the number of signatures and B10 is the base price, here is the
equation I came up with:

=(B10+(C2-1)*5)

Is there an IF command I can add to this to make it work for signatures above
10? I'm losing sleep over this so any help is appreciated. Does anyone else
stay up until 2 AM trying to figure things out?

 
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
CONDITIONAL STATEMENT BANJO Excel Worksheet Functions 2 March 31st 08 03:50 PM
Conditional If Statement Moz Excel Discussion (Misc queries) 2 December 1st 07 04:36 PM
Conditional Statement lbraddock Excel Worksheet Functions 0 July 16th 07 10:16 PM
conditional statement mjstizzle New Users to Excel 1 June 29th 05 05:18 PM
Conditional if statement Matt Stanley Excel Worksheet Functions 2 November 10th 04 04:47 AM


All times are GMT +1. The time now is 06:51 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"