Home |
Search |
Today's Posts |
#3
|
|||
|
|||
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 hours and can't get it to work right. Can anyone help? The criteria is--If less than 400 pages, but not equal to 0, then charge 2.00 minimum. If more than 400 pages, then charge is .50 per 100. Thanks, Barb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
time formula question... | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
formula Question | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |