Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.) |
#2
|
|||
|
|||
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.) |
#3
|
|||
|
|||
|
#4
|
|||
|
|||
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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to increase a number which is held in a cell by 1 | New Users to Excel | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
returning a text cell based on a number cell | Excel Worksheet Functions |