Round up

[mks]

Hi ,

Can you please help me to update following formula to give value upto two decimal places.

Range(sOut).Value = ((Range(sInp).Value * (ActiveCell.Value)) & " Sqm ")

thanks

 

[Ralajer]

The title of the post is round up do want it to always round up or do you want the standard rounding.

If standard rounding use the Format Function.
Format(1.235, "0.00") = "1.24"
Format(1.234, "0.00") = "1.23"

Range(sOut).Value = Format((Range(sInp).Value * (ActiveCell.Value)), "0.00") & " Sqm "

To force a round up at two decimal places use the Excel Ceiling Function with the Format function for 0th in the decimal places.
Format(Ceiling(1.230001, 0.01), "0.00") = "1.24"

Range(sOut).Value= Format(Application.WorksheetFunction.Ceiling(Range(sInp).Value * (ActiveCell.Value), 0.01), "0.00") & "sqm "

 

[mks]

Thanks Ralajer