| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displayed results in a cell
Can the product of a formula be rounded to the nearest number divided by 10?
If so how? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function results not displayed in cell | Excel Worksheet Functions | |||
| format decimals displayed based on results | Excel Discussion (Misc queries) | |||
| CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
| Can multiple cell results be displayed in a single cell? | Excel Discussion (Misc queries) | |||
| Function Formula is displayed not results | Excel Worksheet Functions | |||
Linear Mode
