| how to round number up to two decimal places | arun khatri | 9/20/11 12:41 AM | I just need to know how could we round a number returned up to two decimal places. |
| Re: how to round number up to two decimal places | ScampMichael | 9/20/11 5:09 AM | If you need to do it in a script the javascript could be: function ceiling2(number) { var ceiling2; return ceiling2 = Math.ceil(number*100)/100;} There is a spreadsheet formula:=CEILING(number, .01) |
| Re: how to round number up to two decimal places | Gregair13 | 4/12/12 1:17 AM | Where would the =CEILING(number, .01) go in the following formula? =SUM(C3, D3, E3, F3, G3, H3, I3, J3, K3, L3, M3, N3)/B18 |
| Re: how to round number up to two decimal places | Albfranyeck | 4/12/12 2:01 AM | On Tuesday, September 20, 2011 2:09:06 PM UTC+2, ScampMichael wrote:If you need to do it in a script the javascript could be: function ceiling2(number) { var ceiling2; return ceiling2 = Math.ceil(number*100)/100;} There is a spreadsheet formula:=CE |
| Re: how to round number up to two decimal places | ScampMichael | 4/12/12 9:52 AM | I would imagine:=CEILING( SUM(C3, D3, E3, F3, G3, H3, I3, J3, K3, L3, M3, N3)/B18 , .01) |