Jamie Ramos
New Member
- Joined
- Jun 10, 2011
- Messages
- 28
I have a sheet where I am calculating the amount of product need based on footage.
The lengths are 40, 16, 8 (Columns D4,E4,F4). In rows G4-I4 the formula should be calculating how many of each piece we need based on the total footage (B4). I think it is the INT that is wrong but when I try to use ROUND it only works in H4 but then shows I4 as a negative number. I think INT makes it round down from what I have read. For this particular product I need to send more product than less. Ie if the total is 331 feet I would send 336 rather than 328 (which is what I currently get)
G4==INT($B4/D4)
H4-=INT(($B4-SUMPRODUCT(D4:$D4,G4:$G4))/E4)
I4= I cant figure out.
Thank you in advance for your help.
The lengths are 40, 16, 8 (Columns D4,E4,F4). In rows G4-I4 the formula should be calculating how many of each piece we need based on the total footage (B4). I think it is the INT that is wrong but when I try to use ROUND it only works in H4 but then shows I4 as a negative number. I think INT makes it round down from what I have read. For this particular product I need to send more product than less. Ie if the total is 331 feet I would send 336 rather than 328 (which is what I currently get)
G4==INT($B4/D4)
H4-=INT(($B4-SUMPRODUCT(D4:$D4,G4:$G4))/E4)
I4= I cant figure out.
Thank you in advance for your help.
