multiply by actual number in cell
 

I am using the following formula to obtain a whole number in cell H4:
=IF(C4+0,C4/62+0.5,0)

When I enter a quantity in C4, this then gives me the number of items as a
whole number that I need in I4. I then need to multiply H4 (the whole number,
not any fractional part) x 150 to get an amount in cell D4.

TIA - read below for more info if needed.

(If further explanation will help, C4 is the number of sheets of metal I'm
shipping. Each pallet can hold 61 sheets, so that determines the number of
pallets in H4. I must then multiply the weight of each pallet - 150 - times
the number of pallets. Therefore, fractions won't give me correct info. I
know I can ROUNDUP H4 and multiply x 150, but hope there's an actual formula
that will work as well.)

What is the purpose of add ing zero to C4?
Do you mean =IF(C40,C4/62+0.5,0)

If you what whole number, you could use =IF(C40, INT(C4/62 +0.5), 0)

Not sure what you mean by "actual formula". Why is the use of ROUNDUP not
OK?

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"CJ Cerezo" wrote in message
...
I am using the following formula to obtain a whole number in cell H4:
=IF(C4+0,C4/62+0.5,0)

When I enter a quantity in C4, this then gives me the number of items as a
whole number that I need in I4. I then need to multiply H4 (the whole
number,
not any fractional part) x 150 to get an amount in cell D4.

TIA - read below for more info if needed.

(If further explanation will help, C4 is the number of sheets of metal I'm
shipping. Each pallet can hold 61 sheets, so that determines the number of
pallets in H4. I must then multiply the weight of each pallet - 150 -
times
the number of pallets. Therefore, fractions won't give me correct info. I
know I can ROUNDUP H4 and multiply x 150, but hope there's an actual
formula
that will work as well.)

have a look in HELP index for INT

--
Don Guillett
SalesAid Software

"CJ Cerezo" wrote in message
...
I am using the following formula to obtain a whole number in cell H4:
=IF(C4+0,C4/62+0.5,0)

When I enter a quantity in C4, this then gives me the number of items as a
whole number that I need in I4. I then need to multiply H4 (the whole
number,
not any fractional part) x 150 to get an amount in cell D4.

TIA - read below for more info if needed.

(If further explanation will help, C4 is the number of sheets of metal I'm
shipping. Each pallet can hold 61 sheets, so that determines the number of
pallets in H4. I must then multiply the weight of each pallet - 150 -
times
the number of pallets. Therefore, fractions won't give me correct info. I
know I can ROUNDUP H4 and multiply x 150, but hope there's an actual
formula
that will work as well.)

Thank you so much, Bernard! That formula did the trick. I was using a formula
given me by someone else (thus why I added the zero to C4. Not sure why
ROUNDUP wasn't working properly, but this solved my problem.

Many thanks for the quick response.

Cheryle

"Bernard Liengme" wrote:

What is the purpose of add ing zero to C4?
Do you mean =IF(C40,C4/62+0.5,0)

If you what whole number, you could use =IF(C40, INT(C4/62 +0.5), 0)

Not sure what you mean by "actual formula". Why is the use of ROUNDUP not
OK?

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"CJ Cerezo" wrote in message
...
I am using the following formula to obtain a whole number in cell H4:
=IF(C4+0,C4/62+0.5,0)

When I enter a quantity in C4, this then gives me the number of items as a
whole number that I need in I4. I then need to multiply H4 (the whole
number,
not any fractional part) x 150 to get an amount in cell D4.

TIA - read below for more info if needed.

(If further explanation will help, C4 is the number of sheets of metal I'm
shipping. Each pallet can hold 61 sheets, so that determines the number of
pallets in H4. I must then multiply the weight of each pallet - 150 -
times
the number of pallets. Therefore, fractions won't give me correct info. I
know I can ROUNDUP H4 and multiply x 150, but hope there's an actual
formula
that will work as well.)