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 muc
fabric I require in 1.5 metre lengths, so I want to round figures up t
the nearest multiple of 1.5. Ie 3.24m rounded up to 4.5m, or 5.94 up t
6m.
Can this be done, and how?
Thanks in advance, Scot

 

[Domenic]

Try the following...

=CEILING(A1,1.5)

Hope this helps!

 

[Scott in NZ]

Thanks Domenic, that works.
Awesome, Cheers Scot