| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
thank you. If my number 10.45 is in cell b5, coming from a formula b4*1.5,
how do I do the formula? =b5.....? thank you -- MikeB94518 "Don Guillett" wrote: one way? =INT(C12)+1-0.05 -- Don Guillett SalesAid Software "MikeB94518" wrote in message ... I have various prices / 5.26, 2.14, 16.58 that I want to round up to the next .95 so they will be 5.95, 2.95, 16.95. Is there an automated way to do this? Thank you. -- MikeB94518 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round a number in nested function | Excel Worksheet Functions | |||
| Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| How do i round up a price to the nearest 5,10,15 etc pence | Excel Worksheet Functions | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Threaded Mode
