Need help with logic statement

Okay, this will probably be the most horrible explanation ever of a problem but here goes...

I have written a program which calculates weld times for job quoting. It works well when I use whole or half numbers for my weld thickness (1 or 0.5, 2 or 2.5).

The problem exists when I enter a number such as 0.9 in my thickness (G13). When I do this it gives me a Zero (0) value near the bottom J51:J90. It does this because of my logic statement (=IF(A51=$K$13,H51,0)) When I enter the odd number in the G13 (such as 0.9) it will output a zero because it does not match the precedent.

Can someone take a look at this for me and see where I went wrong? Is there an easier way to do this?

https://onedrive.live.com/redir?resi...nt=file%2cxlsx

I have attached a link and an attachment. They should be the same file.

I'm not 100% on what you're doing here, so I might have the logic wrong, but I think you can just do this instead:

Please Login or Register  to view this content.

In K13, change to the following:

=roundup(G13/F13,0)

This creates a whole number that will work on your list.

Hope that helps.

-Z

OMG I LOVE YOU. This forum is amazing. Thank you, everyone, for taking a look at my problem.

Originally Posted by Zodeeak

In K13, change to the following:

=roundup(G13/F13,0)

This creates a whole number that will work on your list.

Hope that helps.

-Z