Help
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.
I am attempting to enter a formula in excel but keep hiting errors. What I am attempting to do is have the spread sheet auto complete when 0 to 10 tons but zero for balance of the field but if between 10 to 20 enter the weight but no figure in 0 to 10 etc so when i enter the tons it will automaticly divid and post.
BLACK CWT EPOXY CWT WEIGHT "TO
DETAILING" AM/PM Date Complete 0 to 10 10 to 20 20 to 40 40 to 100 100+ 1000+ State
42243 21.12 9/3/08 21.12
8369 $78.59 4.68 9/4/08 9/10/08 4.68
14560 $74.21 7.28 9/4/08 9/10/08 7.28
20960 10.48 10.48
22965 $69.25 11.48 9/9/08 9/10/08 11.48
3936 $75.24 1.97 9/9/08 1.97
0 $- 0.00 9/11/08 Canceled 9/12/08 0
101871 $70.56 50.94 9/11/08 50.94
BLACK CWT EPOXY CWT WEIGHT "TO
DETAILING" AM/PM Date Complete 0 to 10 10 to 20 20 to 40 40 to 100 100+ 1000+ State
42243 21.12 9/3/08 21.12
8369 $78.59 4.68 9/4/08 9/10/08 4.68
14560 $74.21 7.28 9/4/08 9/10/08 7.28
20960 10.48 10.48
22965 $69.25 11.48 9/9/08 9/10/08 11.48
3936 $75.24 1.97 9/9/08 1.97
0 $- 0.00 9/11/08 Canceled 9/12/08 0
101871 $70.56 50.94 9/11/08 50.94
Back to top
