LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default Days by month and IF statement.

If A1 = 6/1/2006, can B1 = the number of days in June w/o using a VLOOKUP?

Im trying to embed a couple of conditions in an IF statement and i don't
know where to begin.

I have a fixed volume of 500/day; July = 31 days; total 15500 for july.

I need to charge .442 for the first 10000 per unit, 1.327 for the next 100
units, 1.098 forthe next 140, and .9255 for the remaining units, which in
this case are 5260.

I made A1 = 500x31 (15500) and then have the formula point at it.

How can i make C1 read A1 and then give me the correct output for that volume?

Thank you for all your help in advance.
 
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
holiday dates bucci Excel Worksheet Functions 4 June 15th 06 09:35 AM
function to fill all days of month to end of month YaHootie Excel Worksheet Functions 10 May 1st 06 06:01 AM
Calculate Days in a Month LGG Excel Discussion (Misc queries) 6 January 13th 06 06:31 PM
Working days left in the month compared to previous months qwopzxnm Excel Worksheet Functions 8 October 24th 05 08:00 PM
Calculate running target by days in the month Robert Excel Worksheet Functions 2 July 4th 05 06:14 AM


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"