| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROundup
I thought I posted this but I cant find it. Apologies if this is
repeating. But I need a formula, for cell B1, that will roundup the figure in A1 to the nearest $2 ie, if A1 = $22.50, the figure in B1 needs to be $24.00 Anyone got any ideas? TIA Esra |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ROundup
Maybe
=CEILING(A1,2) Try that in B1. Mike "Esradekan" wrote: I thought I posted this but I cant find it. Apologies if this is repeating. But I need a formula, for cell B1, that will roundup the figure in A1 to the nearest $2 ie, if A1 = $22.50, the figure in B1 needs to be $24.00 Anyone got any ideas? TIA Esra |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ROundup
On Oct 31, 10:31 pm, Mike H wrote:
Maybe =CEILING(A1,2) Try that in B1. Mike "Esradekan" wrote: I thought I posted this but I cant find it. Apologies if this is repeating. But I need a formula, for cell B1, that will roundup the figure in A1 to the nearest $2 ie, if A1 = $22.50, the figure in B1 needs to be $24.00 Anyone got any ideas? TIA Esra- Hide quoted text - - Show quoted text - Works terrific, thanks very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =ROUNDUP(INT(0.xxx)) | Excel Worksheet Functions | |||
| roundup by 16s | Excel Worksheet Functions | |||
| RoundUp help! | New Users to Excel | |||
| how to use roundup | Excel Discussion (Misc queries) | |||
| ROUNDUP | Excel Discussion (Misc queries) | |||
Linear Mode
