software

I need to set up a spreadsheet showing the different rates for parts of a page.

Rates 1/8 page=$550, 1/4 page=$800, 1/2page=$1,000 and full page=$1500 with
a 25% premium for the months of Sept, Oct, and Nov.I want to be able in insert the page fraction purchased and in a column
below give me the dollars amount?

Spreadsheet would look like this?

Vendor Name Jan Feb March April May June Ect
XYZ 1/8 1/4 1 0 0 0

550 800 1500 0 0 0

Hi!

You'd have to format the cells where you enter the page size as a FRACTION
(up to one digit)

Then:

=IF(B2=0,quot;quot;,LOOKUP(B2,{0.125,550;0.25,800;0.5,1000 ;1,1500})*IF(OR(B1={quot;Septquot;,quot;Octquot;,quot;NOVquot;}),1.25,1))

Biff

quot;gravity003quot; gt; wrote in message
...
gt;I need to set up a spreadsheet showing the different rates for parts of a
gt;page.
gt;
gt; Rates 1/8 page=$550, 1/4 page=$800, 1/2page=$1,000 and full page=$1500
gt; with
gt; a 25% premium for the months of Sept, Oct, and Nov.
gt;
gt;
gt; I want to be able in insert the page fraction purchased and in a column
gt; below give me the dollars amount?
gt;
gt; Spreadsheet would look like this?
gt;
gt; Vendor Name Jan Feb March April May June Ect
gt; XYZ 1/8 1/4 1 0 0 0
gt;
gt; 550 800 1500 0 0 0
Everything works except for the premium rate of 25% for Sept, Oct and Nov.
Thanks for your help. Now if I or any one else figure out how to do the
premium rate.

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; You'd have to format the cells where you enter the page size as a FRACTION
gt; (up to one digit)
gt;
gt; Then:
gt;
gt; =IF(B2=0,quot;quot;,LOOKUP(B2,{0.125,550;0.25,800;0.5,1000 ;1,1500})*IF(OR(B1={quot;Septquot;,quot;Octquot;,quot;NOVquot;}),1.25,1))
gt;
gt; Biff
gt;
gt; quot;gravity003quot; gt; wrote in message
gt; ...
gt; gt;I need to set up a spreadsheet showing the different rates for parts of a
gt; gt;page.
gt; gt;
gt; gt; Rates 1/8 page=$550, 1/4 page=$800, 1/2page=$1,000 and full page=$1500
gt; gt; with
gt; gt; a 25% premium for the months of Sept, Oct, and Nov.
gt; gt;
gt; gt;
gt; gt; I want to be able in insert the page fraction purchased and in a column
gt; gt; below give me the dollars amount?
gt; gt;
gt; gt; Spreadsheet would look like this?
gt; gt;
gt; gt; Vendor Name Jan Feb March April May June Ect
gt; gt; XYZ 1/8 1/4 1 0 0 0
gt; gt;
gt; gt; 550 800 1500 0 0 0
gt;
gt;
gt;

gt; Everything works except for the premium rate of 25% for Sept, Oct and Nov.

Explain what that means?

Biff

quot;gravity003quot; gt; wrote in message
...
gt; Everything works except for the premium rate of 25% for Sept, Oct and Nov.
gt; Thanks for your help. Now if I or any one else figure out how to do the
gt; premium rate.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; You'd have to format the cells where you enter the page size as a
gt;gt; FRACTION
gt;gt; (up to one digit)
gt;gt;
gt;gt; Then:
gt;gt;
gt;gt; =IF(B2=0,quot;quot;,LOOKUP(B2,{0.125,550;0.25,800;0.5,1000 ;1,1500})*IF(OR(B1={quot;Septquot;,quot;Octquot;,quot;NOVquot;}),1.25,1))
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;gravity003quot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I need to set up a spreadsheet showing the different rates for parts of
gt;gt; gt;a
gt;gt; gt;page.
gt;gt; gt;
gt;gt; gt; Rates 1/8 page=$550, 1/4 page=$800, 1/2page=$1,000 and full page=$1500
gt;gt; gt; with
gt;gt; gt; a 25% premium for the months of Sept, Oct, and Nov.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; I want to be able in insert the page fraction purchased and in a column
gt;gt; gt; below give me the dollars amount?
gt;gt; gt;
gt;gt; gt; Spreadsheet would look like this?
gt;gt; gt;
gt;gt; gt; Vendor Name Jan Feb March April May June Ect
gt;gt; gt; XYZ 1/8 1/4 1 0 0 0
gt;gt; gt;
gt;gt; gt; 550 800 1500 0 0 0
gt;gt;
gt;gt;
gt;gt;
We charge the base rate plus 25% if the vendor runs an ad in the months of
Sept, Oct and Nov. The formula you gave me enters the base figure of (1/8
page $550 and not the correct rate of 687.50 for these months) and does give
the premium rate.

quot;Biffquot; wrote:

gt; gt; Everything works except for the premium rate of 25% for Sept, Oct and Nov.
gt;
gt; Explain what that means?
gt;
gt; Biff
gt;
gt; quot;gravity003quot; gt; wrote in message
gt; ...
gt; gt; Everything works except for the premium rate of 25% for Sept, Oct and Nov.
gt; gt; Thanks for your help. Now if I or any one else figure out how to do the
gt; gt; premium rate.
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; You'd have to format the cells where you enter the page size as a
gt; gt;gt; FRACTION
gt; gt;gt; (up to one digit)
gt; gt;gt;
gt; gt;gt; Then:
gt; gt;gt;
gt; gt;gt; =IF(B2=0,quot;quot;,LOOKUP(B2,{0.125,550;0.25,800;0.5,1000 ;1,1500})*IF(OR(B1={quot;Septquot;,quot;Octquot;,quot;NOVquot;}),1.25,1))
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;gravity003quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I need to set up a spreadsheet showing the different rates for parts of
gt; gt;gt; gt;a
gt; gt;gt; gt;page.
gt; gt;gt; gt;
gt; gt;gt; gt; Rates 1/8 page=$550, 1/4 page=$800, 1/2page=$1,000 and full page=$1500
gt; gt;gt; gt; with
gt; gt;gt; gt; a 25% premium for the months of Sept, Oct, and Nov.
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; I want to be able in insert the page fraction purchased and in a column
gt; gt;gt; gt; below give me the dollars amount?
gt; gt;gt; gt;
gt; gt;gt; gt; Spreadsheet would look like this?
gt; gt;gt; gt;
gt; gt;gt; gt; Vendor Name Jan Feb March April May June Ect
gt; gt;gt; gt; XYZ 1/8 1/4 1 0 0 0
gt; gt;gt; gt;
gt; gt;gt; gt; 550 800 1500 0 0 0
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

We must be losing something it translation.

Take a look at this sample file:

s44.yousendit.com/d.aspx?id=1...03095PFIE7985J

Biff

quot;gravity003quot; gt; wrote in message
...
gt; We charge the base rate plus 25% if the vendor runs an ad in the months of
gt; Sept, Oct and Nov. The formula you gave me enters the base figure of (1/8
gt; page $550 and not the correct rate of 687.50 for these months) and does
gt; give
gt; the premium rate.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; gt; Everything works except for the premium rate of 25% for Sept, Oct and
gt;gt; gt; Nov.
gt;gt;
gt;gt; Explain what that means?
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;gravity003quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Everything works except for the premium rate of 25% for Sept, Oct and
gt;gt; gt; Nov.
gt;gt; gt; Thanks for your help. Now if I or any one else figure out how to do
gt;gt; gt; the
gt;gt; gt; premium rate.
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi!
gt;gt; gt;gt;
gt;gt; gt;gt; You'd have to format the cells where you enter the page size as a
gt;gt; gt;gt; FRACTION
gt;gt; gt;gt; (up to one digit)
gt;gt; gt;gt;
gt;gt; gt;gt; Then:
gt;gt; gt;gt;
gt;gt; gt;gt; =IF(B2=0,quot;quot;,LOOKUP(B2,{0.125,550;0.25,800;0.5,1000 ;1,1500})*IF(OR(B1={quot;Septquot;,quot;Octquot;,quot;NOVquot;}),1.25,1))
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;gravity003quot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I need to set up a spreadsheet showing the different rates for parts
gt;gt; gt;gt; gt;of
gt;gt; gt;gt; gt;a
gt;gt; gt;gt; gt;page.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Rates 1/8 page=$550, 1/4 page=$800, 1/2page=$1,000 and full
gt;gt; gt;gt; gt; page=$1500
gt;gt; gt;gt; gt; with
gt;gt; gt;gt; gt; a 25% premium for the months of Sept, Oct, and Nov.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I want to be able in insert the page fraction purchased and in a
gt;gt; gt;gt; gt; column
gt;gt; gt;gt; gt; below give me the dollars amount?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Spreadsheet would look like this?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Vendor Name Jan Feb March April May June Ect
gt;gt; gt;gt; gt; XYZ 1/8 1/4 1 0 0 0
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; 550 800 1500 0 0 0
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Yes I do not why it is not doing it correctly. I can see on your example it
is working correctly. I think you for your help. I will change the logic
for Sept, Oct and Nov and it now gives the correct amount. Most be something
in the different versions of exel.

I can now lay out the report and again think for your assistance. You will
save me hours of manually entering data.

quot;Biffquot; wrote:

gt; We must be losing something it translation.
gt;
gt; Take a look at this sample file:
gt;
gt; s44.yousendit.com/d.aspx?id=1...03095PFIE7985J
gt;
gt; Biff
gt;
gt; quot;gravity003quot; gt; wrote in message
gt; ...
gt; gt; We charge the base rate plus 25% if the vendor runs an ad in the months of
gt; gt; Sept, Oct and Nov. The formula you gave me enters the base figure of (1/8
gt; gt; page $550 and not the correct rate of 687.50 for these months) and does
gt; gt; give
gt; gt; the premium rate.
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; gt; Everything works except for the premium rate of 25% for Sept, Oct and
gt; gt;gt; gt; Nov.
gt; gt;gt;
gt; gt;gt; Explain what that means?
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;gravity003quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Everything works except for the premium rate of 25% for Sept, Oct and
gt; gt;gt; gt; Nov.
gt; gt;gt; gt; Thanks for your help. Now if I or any one else figure out how to do
gt; gt;gt; gt; the
gt; gt;gt; gt; premium rate.
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Biffquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Hi!
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; You'd have to format the cells where you enter the page size as a
gt; gt;gt; gt;gt; FRACTION
gt; gt;gt; gt;gt; (up to one digit)
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Then:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; =IF(B2=0,quot;quot;,LOOKUP(B2,{0.125,550;0.25,800;0.5,1000 ;1,1500})*IF(OR(B1={quot;Septquot;,quot;Octquot;,quot;NOVquot;}),1.25,1))
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Biff
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;gravity003quot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt;I need to set up a spreadsheet showing the different rates for parts
gt; gt;gt; gt;gt; gt;of
gt; gt;gt; gt;gt; gt;a
gt; gt;gt; gt;gt; gt;page.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Rates 1/8 page=$550, 1/4 page=$800, 1/2page=$1,000 and full
gt; gt;gt; gt;gt; gt; page=$1500
gt; gt;gt; gt;gt; gt; with
gt; gt;gt; gt;gt; gt; a 25% premium for the months of Sept, Oct, and Nov.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; I want to be able in insert the page fraction purchased and in a
gt; gt;gt; gt;gt; gt; column
gt; gt;gt; gt;gt; gt; below give me the dollars amount?
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Spreadsheet would look like this?
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Vendor Name Jan Feb March April May June Ect
gt; gt;gt; gt;gt; gt; XYZ 1/8 1/4 1 0 0 0
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; 550 800 1500 0 0 0
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Ok, glad you got it working.

Thanks for the feedback!

Biff

quot;gravity003quot; gt; wrote in message
...
gt; Yes I do not why it is not doing it correctly. I can see on your example
gt; it
gt; is working correctly. I think you for your help. I will change the logic
gt; for Sept, Oct and Nov and it now gives the correct amount. Most be
gt; something
gt; in the different versions of exel.
gt;
gt; I can now lay out the report and again think for your assistance. You
gt; will
gt; save me hours of manually entering data.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; We must be losing something it translation.
gt;gt;
gt;gt; Take a look at this sample file:
gt;gt;
gt;gt; s44.yousendit.com/d.aspx?id=1...03095PFIE7985J
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;gravity003quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; We charge the base rate plus 25% if the vendor runs an ad in the months
gt;gt; gt; of
gt;gt; gt; Sept, Oct and Nov. The formula you gave me enters the base figure of
gt;gt; gt; (1/8
gt;gt; gt; page $550 and not the correct rate of 687.50 for these months) and does
gt;gt; gt; give
gt;gt; gt; the premium rate.
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; gt; Everything works except for the premium rate of 25% for Sept, Oct
gt;gt; gt;gt; gt; and
gt;gt; gt;gt; gt; Nov.
gt;gt; gt;gt;
gt;gt; gt;gt; Explain what that means?
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;gravity003quot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Everything works except for the premium rate of 25% for Sept, Oct
gt;gt; gt;gt; gt; and
gt;gt; gt;gt; gt; Nov.
gt;gt; gt;gt; gt; Thanks for your help. Now if I or any one else figure out how to do
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; premium rate.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; Hi!
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; You'd have to format the cells where you enter the page size as a
gt;gt; gt;gt; gt;gt; FRACTION
gt;gt; gt;gt; gt;gt; (up to one digit)
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Then:
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; =IF(B2=0,quot;quot;,LOOKUP(B2,{0.125,550;0.25,800;0.5,1000 ;1,1500})*IF(OR(B1={quot;Septquot;,quot;Octquot;,quot;NOVquot;}),1.25,1))
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Biff
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; quot;gravity003quot; gt; wrote in
gt;gt; gt;gt; gt;gt; message
gt;gt; gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;gt; gt;I need to set up a spreadsheet showing the different rates for
gt;gt; gt;gt; gt;gt; gt;parts
gt;gt; gt;gt; gt;gt; gt;of
gt;gt; gt;gt; gt;gt; gt;a
gt;gt; gt;gt; gt;gt; gt;page.
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Rates 1/8 page=$550, 1/4 page=$800, 1/2page=$1,000 and full
gt;gt; gt;gt; gt;gt; gt; page=$1500
gt;gt; gt;gt; gt;gt; gt; with
gt;gt; gt;gt; gt;gt; gt; a 25% premium for the months of Sept, Oct, and Nov.
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; I want to be able in insert the page fraction purchased and in a
gt;gt; gt;gt; gt;gt; gt; column
gt;gt; gt;gt; gt;gt; gt; below give me the dollars amount?
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Spreadsheet would look like this?
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Vendor Name Jan Feb March April May June Ect
gt;gt; gt;gt; gt;gt; gt; XYZ 1/8 1/4 1 0 0
gt;gt; gt;gt; gt;gt; gt; 0
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; 550 800 1500 0 0
gt;gt; gt;gt; gt;gt; gt; 0
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;