Help with formula please

S

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
 
Top