| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
applying rounding formula to entire worksheet
Hi, I have worksheet full of prices that I want to round to the nearest
multiple of 10 then subtract 1 to get a nice price with 9 on the end. (having already multiplied the original numbers by a percent to change currencies) I know how to make $47 into $49 by using =mround(47,10)-1 but how do I apply it to the whole sheet? Paste special Formulas is not working for me... Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help applying a formula to a certain area of the worksheet | Excel Worksheet Functions | |||
| Offset formula on different worksheet | Excel Worksheet Functions | |||
| How can I use one formula to change case on an entire worksheet? | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| need a formula to copy entire row to next worksheet | Excel Worksheet Functions | |||
Threaded Mode
