conditional statement; is that what i need to use?

[vasi]

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]

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?)

 

[gls858]

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?)

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))

 

[vasi]

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 - 17 lines]
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))

 

[vasi]

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

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

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

 

[Roger Govier]

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

--
Regards
Roger Govier

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 - 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))

 

[vasi]

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

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]

 

[gls858]

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

 

[Roger Govier]

Hi

if the value in cell C2 is less than or equal to 10, then take the value in
B10 and add 5 times the figure in C2, after taking away 1 from that value
Otherwise
take the value in B11 and add to it 20 times the values in C2, after taking
away 10 from that value.

--
Regards
Roger Govier

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

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))

 

[vasi via OfficeKB.com]

Thank you for your help on this:

Now, I have a continuation.

I need to show, in a spreadsheet, the price for the initial book and
additional books based on number of signatures. columns that have 8, 9, 10,
11, etc and rows for number of signatures and total number of pages, and
maybe other rows.

The first spread sheet that you helped with now gives me the cost for the
specific number of signatures, but how can i get it to put that result in a
new spreadsheet each time I change the number of signatures? Does what I'm
asking makes sense?

vasi

 

[vasi via OfficeKB.com]

Since this question does not seem to fit the original topic, I decided to
pose this question as a new topic, I hope this did not cause an issue.

Thank you for your help on this:

Now, I have a continuation.

I need to show, in a spreadsheet, the price for the initial book and
additional books based on number of signatures. columns that have 8, 9, 10,
11, etc and rows for number of signatures and total number of pages, and
maybe other rows.

The first spread sheet that you helped with now gives me the cost for the
specific number of signatures, but how can i get it to put that result in a
new spreadsheet each time I change the number of signatures? Does what I'm
asking makes sense?

vasi
[quoted text clipped - 14 lines]

gls858