| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
round up cells to $xx.99
i have cells that i would like to round up to $xx.99 --- $0.30 = $0.99,
$3.44 = $3.99, $227.59 = $227.99 how can i do this? |
|
#2
|
|||
|
|||
|
=IF(A1<1,0.99,INT(A1)+0.99)
where A1 is the cell holding the $$ "RVV" wrote in message ... i have cells that i would like to round up to $xx.99 --- $0.30 = $0.99, $3.44 = $3.99, $227.59 = $227.99 how can i do this? |
|
#3
|
|||
|
|||
|
If your amounts are in Col A. In Col B you could use.
=ceiling(A1,1)-.01 "RVV" wrote: i have cells that i would like to round up to $xx.99 --- $0.30 = $0.99, $3.44 = $3.99, $227.59 = $227.99 how can i do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format cells to round to the nearest thousands without .. | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
