Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with formula please
Hi, can anyone help me create a formula please? I am woking out fabric yields and want Excel to work out how much fabric I require in 1.5 metre lengths, so I want to round figures up to the nearest multiple of 1.5. Ie 3.24m rounded up to 4.5m, or 5.94 up to 6m. Can this be done, and how? Thanks in advance, Scott -- Scott in NZ ------------------------------------------------------------------------ Scott in NZ's Profile: http://www.excelforum.com/member.php...o&userid=20026 View this thread: http://www.excelforum.com/showthread...hreadid=346117 |
#2
|
|||
|
|||
Try the following... =CEILING(A1,1.5) Hope this helps! Scott in NZ Wrote: Hi, can anyone help me create a formula please? I am woking out fabric yields and want Excel to work out how much fabric I require in 1.5 metre lengths, so I want to round figures up to the nearest multiple of 1.5. Ie 3.24m rounded up to 4.5m, or 5.94 up to 6m. Can this be done, and how? Thanks in advance, Scott -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=346117 |
#3
|
|||
|
|||
Thanks Domenic, that works. Awesome, Cheers Scott -- Scott in NZ ------------------------------------------------------------------------ Scott in NZ's Profile: http://www.excelforum.com/member.php...o&userid=20026 View this thread: http://www.excelforum.com/showthread...hreadid=346117 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |