How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 37649
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

Actual hours divided by cartons in spread sheet Not throwing

This answer was rated:

Actual hours divided by cartons in spread sheet Not throwing any exception issues just giving me

=IF(M3>N3,(1-M3)*24+N3*24-O3*24,(N3-M3-O3)*24) is the data formula
Actual pick hours are 1.065 CTNS are 76 so J/I its fine apart from the following two
11 $40.00 122 $2,196.00 0.001 123 $2,214.00 11:19 11:19 88560.0 87840.0 $0.06

SAT MORNING DRY 12020 $41.00 286 $558.05 0.01 27 $52.68 18:41 18:42 2160.0 22880.0 $0.51

As you can see its not throwing an issue at all but I need to omit the zeros as its throwing massive numbers Ideas
Thank you for your question, my name is Richard.

Can I look at the sheet please, it is easier.

- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 4 years ago.


What is the password XXXXX set?
Customer: replied 4 years ago.



So for instance, Cell I203 should be 0?

It should only show whole numbers?
Customer: replied 4 years ago.

This cell should not report in the P column there is two instances of this I203 and I287 when the column P formula is J3/I3 but need to remove those zeros as its throwing all the ctn info out

Sorry but that is not clear.

What do you want the value to be instead of 0.0001 ?

you say remove the zeros, but to do that you need to change the number

So what should it be?
Customer: replied 4 years ago.

I want it to say zero and not throw a negative number like when I went to school zero divided by 0 is 0 now 123 divded 0.001 should be zero ?

No, as if it is 0 you cannot dived by it.

Nothing can be divded by 0

Should I make it so P is 0 when I is 0.0001?
Customer: replied 4 years ago.

Yes please that would be great if the formula would show it

thanks Anthony

This is done Anthony

You can download it from

<a href= Formatting.xls" Formatting.xls

Let me know if you have any difficulties please

Richard and 3 other Microsoft Office Specialists are ready to help you