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?

One more complication: For signatures above 10 there is a new base price.

(Is there an edit mode so the OP can edit his own message?)

vasi wrote:
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?

vasi wrote:
One more complication: For signatures above 10 there is a new base price.

(Is there an edit mode so the OP can edit his own message?)

vasi wrote:
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?


If you can put the base price for over ten in another cell say B11 then
something like this should work

=IF(C2<=10,(B10+(C2-1)*5),(B11+(C2-1)*20))

That didn't work, but maybe I'm not understanding the situation.

Could you state the formula in words so then maybe I can understand the
formula you offered? I've been using excel for only three days!

For signatures above 10, let's use a base price is 175, so according to their
price list, for a 12 signature book, the price should be 215; the formula
rendered a value of 395

Thank you very much for taking an interest in this and helping me!

vasi


gls858 wrote:
One more complication: For signatures above 10 there is a new base price.

[quoted text clipped - 17 lines]
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?

If you can put the base price for over ten in another cell say B11 then
something like this should work

=IF(C2<=10,(B10+(C2-1)*5),(B11+(C2-1)*20))

I don't know why but when I assigned a value for B11 as -5, it renders the
correct value for all signatures. I would like to understand how this works,
but for now, i'm happy enough that it worked.

thank you

vasi

vasi wrote:
That didn't work, but maybe I'm not understanding the situation.

Could you state the formula in words so then maybe I can understand the
formula you offered? I've been using excel for only three days!

For signatures above 10, let's use a base price is 175, so according to their
price list, for a 12 signature book, the price should be 215; the formula
rendered a value of 395

Thank you very much for taking an interest in this and helping me!

vasi

One more complication: For signatures above 10 there is a new base price.

[quoted text clipped - 6 lines]

=IF(C2<=10,(B10+(C2-1)*5),(B11+(C2-1)*20))

Hi
Try
=IF(C2<=10,(B10+(C2-1)*5),(B11+(C2-10)*20))

--
Regards
Roger Govier

"vasi" <u46978@uwe wrote in message news:8bce40d16e74d@uwe...
That didn't work, but maybe I'm not understanding the situation.

Could you state the formula in words so then maybe I can understand the
formula you offered? I've been using excel for only three days!

For signatures above 10, let's use a base price is 175, so according to
their
price list, for a 12 signature book, the price should be 215; the formula
rendered a value of 395

Thank you very much for taking an interest in this and helping me!

vasi


gls858 wrote:
One more complication: For signatures above 10 there is a new base
price.

[quoted text clipped - 17 lines]
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?

If you can put the base price for over ten in another cell say B11 then
something like this should work

=IF(C2<=10,(B10+(C2-1)*5),(B11+(C2-1)*20))

Roger:

Your formula works perfectly! Thank you!

Now, please help me understand how it worked? Can you state the equation you
offered in words?

vasi

Roger Govier wrote:
Hi
Try
=IF(C2<=10,(B10+(C2-1)*5),(B11+(C2-10)*20))

That didn't work, but maybe I'm not understanding the situation.

[quoted text clipped - 22 lines]

=IF(C2<=10,(B10+(C2-1)*5),(B11+(C2-1)*20))

Roger Govier wrote:
Hi
Try
=IF(C2<=10,(B10+(C2-1)*5),(B11+(C2-10)*20))

Thanks Roger. I see my mistake now

Vasi,

An if statement works like this

_If (Logical test, (value if true),(value if false))

So if sigs are less than or equal to 10 then the logical test is true
and first forumla is used if it's greater that ten the the test is fasle
and the second formula is used. Roger used C2-10 in the second formula
because the base there already included ten sigs.

gls858