Re: Formula to figure ad schedules
Re: Formula to figure ad schedules
Source: http://www.tech−archive.net/Archive/Excel/microsoft.public.excel.worksheet.functions/2006−03/msg00223.html
• From: "gravity003" • Date: Thu, 2 Mar 2006 07:49:32 −0800 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. "Biff" wrote:
We must be losing something it translation. Take a look at this sample file: http://s44.yousendit.com/d.aspx?id=1F1WUIZ0V0603095PFIE7985J Biff "gravity003" wrote in message news:F69064A9−AF54−4175−9989−B2CFCBE24A44@xxxxxxxxxxxxxxxx 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. "Biff" wrote:
Everything works except for the premium rate of 25% for Sept, Oct and Nov.
Explain what that means?
Re: Formula to figure ad schedules
1
Re: Formula to figure ad schedules Biff "gravity003" wrote in message news:080B19C4−5253−46F8−A5CD−60C4275C4614@xxxxxxxxxxxxxxxx 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. "Biff" wrote:
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,"",LOOKUP(B2,{0.125,550;0.25,800;0.5,1000;1,1500})*IF(OR(B1 Biff
"gravity003" wrote in message news:11D552D1−FEB3−45E0−9402−E0AE336C576A@xxxxxxxxxxxxxxxx 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, Re: Formula to figure ad schedules 2
Re: Formula to figure ad schedules 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
Re: Formula to figure ad schedules
3
Re: Formula to figure ad schedules .
Re: Formula to figure ad schedules
4