| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding up the result of an IF function
I have this same issue. Could you write what this translates to in English
please so I can use/understand the logic behind it? Thank you "Frank Kabel" wrote: Hi try =CEILING(your_formula,1000) -- Regards Frank Kabel Frankfurt, Germany Tim wrote: I have entered the IF function in a cell, and that function is working properly. I would like the resulting number to be rounded up to the next higher multiple of 1,000. I have tried using the MROUND function, but am not able to nest it with the IF function. Any help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding up the result of an IF function
Round the result of your_formula up (away from zero) to the next whole
thousand. In article , donnaK wrote: I have this same issue. Could you write what this translates to in English please so I can use/understand the logic behind it? Thank you "Frank Kabel" wrote: Hi try =CEILING(your_formula,1000) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding up the result of an IF function
Donna
From Help on Ceiling.......... CEILING(number,significance) Number is the value you want to round. Significance is the multiple to which you want to round. See more on Help for examples. Gord Dibben Excel MVP On Thu, 8 Dec 2005 11:08:03 -0800, donnaK wrote: I have this same issue. Could you write what this translates to in English please so I can use/understand the logic behind it? Thank you "Frank Kabel" wrote: Hi try =CEILING(your_formula,1000) -- Regards Frank Kabel Frankfurt, Germany Tim wrote: I have entered the IF function in a cell, and that function is working properly. I would like the resulting number to be rounded up to the next higher multiple of 1,000. I have tried using the MROUND function, but am not able to nest it with the IF function. Any help would be greatly appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding up the result of an IF function
Thank you... that is helpful.
"Gord Dibben" wrote: Donna From Help on Ceiling.......... CEILING(number,significance) Number is the value you want to round. Significance is the multiple to which you want to round. See more on Help for examples. Gord Dibben Excel MVP On Thu, 8 Dec 2005 11:08:03 -0800, donnaK wrote: I have this same issue. Could you write what this translates to in English please so I can use/understand the logic behind it? Thank you "Frank Kabel" wrote: Hi try =CEILING(your_formula,1000) -- Regards Frank Kabel Frankfurt, Germany Tim wrote: I have entered the IF function in a cell, and that function is working properly. I would like the resulting number to be rounded up to the next higher multiple of 1,000. I have tried using the MROUND function, but am not able to nest it with the IF function. Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| Date & Time | New Users to Excel | |||
| How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Amount or Numbers in Words | New Users to Excel | |||
Linear Mode
