| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: Round formula up in $5. increments =+(M4*1.1)+M4
I have formulas that I want to round up to the nearest $5.00 My formula is
=+(M4*1.1)+M4. I have tried =mround, but I am doing something wrong. Do I need to freeze part of the formula? Please help! Tx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Round formula up in $5. increments =+(M4*1.1)+M4
=MROUND((M4*1.1)+M4,5)
or =MROUND(M4*2.1,5) Vaya con Dios, Chuck, CABGx3 "Wanda M" wrote: I have formulas that I want to round up to the nearest $5.00 My formula is =+(M4*1.1)+M4. I have tried =mround, but I am doing something wrong. Do I need to freeze part of the formula? Please help! Tx |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Round formula up in $5. increments =+(M4*1.1)+M4
Thank you CLR! Works like a charm and you saved me hours of research!
"CLR" wrote: =MROUND((M4*1.1)+M4,5) or =MROUND(M4*2.1,5) Vaya con Dios, Chuck, CABGx3 "Wanda M" wrote: I have formulas that I want to round up to the nearest $5.00 My formula is =+(M4*1.1)+M4. I have tried =mround, but I am doing something wrong. Do I need to freeze part of the formula? Please help! Tx |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Round formula up in $5. increments =+(M4*1.1)+M4
Happy to help, and thanks for the feedback............
Vaya con Dios, Chuck, CABGx3 "Wanda M" wrote: Thank you CLR! Works like a charm and you saved me hours of research! "CLR" wrote: =MROUND((M4*1.1)+M4,5) or =MROUND(M4*2.1,5) Vaya con Dios, Chuck, CABGx3 "Wanda M" wrote: I have formulas that I want to round up to the nearest $5.00 My formula is =+(M4*1.1)+M4. I have tried =mround, but I am doing something wrong. Do I need to freeze part of the formula? Please help! Tx |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Round formula up in $5. increments =+(M4*1.1)+M4
That'll round to the nearest, but if the OP wanted us to answer the part of
the sentence that said she wanted to round *UP*, then it would be =CEILING(M4*2.1,5) -- David Biddulph "CLR" wrote in message ... =MROUND((M4*1.1)+M4,5) or =MROUND(M4*2.1,5) Vaya con Dios, Chuck, CABGx3 "Wanda M" wrote: I have formulas that I want to round up to the nearest $5.00 My formula is =+(M4*1.1)+M4. I have tried =mround, but I am doing something wrong. Do I need to freeze part of the formula? Please help! Tx |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Round formula up in $5. increments =+(M4*1.1)+M4
Good catch David...........
Vaya con Dios, Chuck, CABGx3 "David Biddulph" wrote: That'll round to the nearest, but if the OP wanted us to answer the part of the sentence that said she wanted to round *UP*, then it would be =CEILING(M4*2.1,5) -- David Biddulph "CLR" wrote in message ... =MROUND((M4*1.1)+M4,5) or =MROUND(M4*2.1,5) Vaya con Dios, Chuck, CABGx3 "Wanda M" wrote: I have formulas that I want to round up to the nearest $5.00 My formula is =+(M4*1.1)+M4. I have tried =mround, but I am doing something wrong. Do I need to freeze part of the formula? Please help! Tx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel calculate time increments in a formula? | Excel Worksheet Functions | |||
| how do I round numbers in .125 increments | Excel Worksheet Functions | |||
| extend my formula with increments of 4 cells | Excel Worksheet Functions | |||
| Need formula to add increments of 0.16 seconds to time | Excel Discussion (Misc queries) | |||
| How do I sum a formula and paste it in 7 cell increments? | Excel Discussion (Misc queries) | |||
Hybrid Mode
