| Home |
| Search |
| Today's Posts |
|
#9
|
|||
|
|||
You are the man, Duke! It worked perfectly!
Barb "Duke Carey" wrote: I think only a slight modification is needed =MAX(2,0.5*A1*CEILING(B1/100,1))*(B10) This will charge $2 for 3 cuts on 100 sheets (instead of $0.50 * 3 cuts * 1 set of 100, or $1.50), and will charge $3.00 for 3 cuts on 101 sheets. "Barb1" wrote: Now they've thrown one more variable into the mix. It might change the whole formula. These are paper cut charges. The charges a .50 per cut for 100 sheets with a 2.00 minimum. In other words, if one sheet has 3 cuts, its .50 per cut per 100 sheets with a minimum charge of 2.00. I have column A1 for cuts and column B1 for # of sheets. Does this make it any more confusing for you because its killing me. Barb "Duke Carey" wrote: A little tighter version: =(MAX(2,0.5*CEILING(A1/100,1)))*(A10) "Duke Carey" wrote: From my answer to your same question 2 days ago Try =(2+((A1400)*0.5*(CEILING(A1/100,1)-4)))*(A10) Which assumes that the charge for 400 is $2, but for 401 it's $2.5 Duke "Barb1" wrote: I have been working with this formula for two days and can't get it to work right. Can anyone help? The criteria is--If column A1 is less than 400 sheets, but not equal to 0, then charge 2.00. If its more than 400 sheets, then charge is .50 per 100. The difficulty has been charging .50 per 100 over 400 sheets. It needs to charge in .50 increments. Thanks, Barb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
