LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Duke Carey
 
Posts: n/a
Default

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
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
Howdo U copy a formula down a column, that uses data in another w. Need Help pasting a formula Excel Worksheet Functions 1 February 25th 05 06:04 PM
time formula question... Greg Excel Discussion (Misc queries) 5 February 25th 05 10:11 AM
Howdo U copy a formula down a column, that uses data in another w. brantty Excel Worksheet Functions 0 February 25th 05 10:11 AM
formula Question danlinksman Excel Discussion (Misc queries) 3 January 25th 05 02:07 PM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM


All times are GMT +1. The time now is 03:18 AM.

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"