| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Function in incremental charges
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
