Displayed results in a cell
 

Can the product of a formula be rounded to the nearest number divided by 10?
If so how?

Displayed results in a cell
 

Do you mean the nearest multiple of 10? If so then

=MROUND(24.5,10) returns 20

=MROUND(25.5,10) retuns 30

--
Regards,

OssieMac


"WavMaster" wrote:

Can the product of a formula be rounded to the nearest number divided by 10?
If so how?

Displayed results in a cell
 

Use following formula
Let your result is in column A then select a cell in column B and enter
following formula
=IF((A1-TRUNC(A1,-1))=5,TRUNC(A1,-1)+10,TRUNC(A1,-1))






Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode

Displayed results in a cell
 

On Feb 7, 7:37*am, WavMaster
wrote:
Can the product of a formula be rounded to the nearest number divided by 10?
If so how?

A1= 28
B1=3
C1=round(A1/B1,-1)=10