roundings formula
I have done a spreadsheet where I divid the number entered
in one cell by a number in a second cell the result being eneter in the third cell. However I need to know how to get the formula to round down this result to two decimal places. Example cell D3 is the sum of C3/B3 but this needs to be rounded down to two decimal places |
=rounddown(C3/b3,2)
Help can be your friend. -- HTH RP (remove nothere from the email address if mailing direct) "Keiron James Keeble" wrote in message ... I have done a spreadsheet where I divid the number entered in one cell by a number in a second cell the result being eneter in the third cell. However I need to know how to get the formula to round down this result to two decimal places. Example cell D3 is the sum of C3/B3 but this needs to be rounded down to two decimal places |
All times are GMT +1. The time now is 08:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com