Help with formula please

[Scott in NZ]

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]

Try the following...

=CEILING(A1,1.5)

Hope this helps!

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]

Thanks Domenic, that works.
Awesome, Cheers Scott