What is the difference between ISO.CEILING and CEILING.PRECISE? (Network Steve Forum)

What is the difference between ISO.CEILING and CEILING.PRECISE?

Hi Folks,

The title says it all - What is the difference between these two functions?

TIA,

July 18th, 2015 5:56pm

Re: ceiling functions

Maybe...

http://www.excel-ticker.com/comparison-and-function-list-of-excel-2010-2007-and-2003/
   "If I compare the functions of Excel 2010 Beta with the Technical Preview of Excel 2010,
    it seems that the function FLOOR.PRECISE has been added and ISO.CEILING has been renamed to CEILING.PRECISE."

http://www.bluepecantraining.com/portfolio/rounding-numbers-removing-decimals-in-excel/
   "CEILING.MATH is only available in Excel 2013, and is renamed from CEILING.PRECISE in Excel 2010."

'---
Jim Cone
http://jmp.sh/K95N3ee

Edited by James Cone 3 hours 46 minutes ago

Free Windows Admin Tool Kit Click here and download it now

July 18th, 2015 8:19pm

Hi Jim,

Thanks for the response. Actually, all three functions are in 2013, while the first two are in 2010. You don't see ISO.CEILING in 2010. And you don't see ISO.CEILING or CEILING.PRECISE in 2013. However, they are all there. You can test this by entering them. My guess in that they are "hidden" because CEILING.MATH incorporates their functionality. (not sure about ISO and PRECISE in 2010). But since these are only guesses on my part I wonders if anyone knows for sure.

Thanks,

Shane

July 19th, 2015 12:12am

Edited by James Cone Sunday, July 19, 2015 3:43 AM

Free Windows Admin Tool Kit Click here and download it now

July 19th, 2015 12:17am

Hi Shane,

As far as I know, the three function (ISO.CEILING,CEILING.PRECISE and CEILING.MATH) are all available in Excel 2013. We can see these article:

ISO.CEILING

CEILING.PRECISE

CEILING.MATH

Then, CEILING.MATH function is a new function of Excel 2013. A little difference:

For more information about these functions, we can see the summary link:

http://exceluser.com/excel_help/functions/overview-of-rounding-functions.htm

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Hope it's helpful.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Edited by George.Zhao CHNMicrosoft contingent staff, Moderator 2 hours 50 minutes ago

July 20th, 2015 12:36am

Hi Shane,

As far as I know, the three function (ISO.CEILING,CEILING.PRECISE and CEILING.MATH) are all available in Excel 2013. We can see these article:

ISO.CEILING

CEILING.PRECISE

CEILING.MATH

Then, CEILING.MATH function is a new function of Excel 2013. A little difference:

For more information about these functions, we can see the summary link:

http://exceluser.com/excel_help/functions/overview-of-rounding-functions.htm

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Hope it's helpful.

Regards,

Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, July 20, 2015 4:42 AM

Free Windows Admin Tool Kit Click here and download it now

July 20th, 2015 4:35am

Hi Shane,

As far as I know, the three function (ISO.CEILING,CEILING.PRECISE and CEILING.MATH) are all available in Excel 2013. We can see these article:

ISO.CEILING

CEILING.PRECISE

CEILING.MATH

Then, CEILING.MATH function is a new function of Excel 2013. A little difference:

For more information about these functions, we can see the summary link:

http://exceluser.com/excel_help/functions/overview-of-rounding-functions.htm

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Hope it's helpful.

Regards,

Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, July 20, 2015 4:42 AM
Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 23 hours 39 minutes ago

July 20th, 2015 4:35am

Hi Shane,

As far as I know, the three function (ISO.CEILING,CEILING.PRECISE and CEILING.MATH) are all available in Excel 2013. We can see these article:

ISO.CEILING

CEILING.PRECISE

CEILING.MATH

Then, CEILING.MATH function is a new function of Excel 2013. A little difference:

For more information about these functions, we can see the summary link:

http://exceluser.com/excel_help/functions/overview-of-rounding-functions.htm

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Hope it's helpful.

Regards,

Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, July 20, 2015 4:42 AM
Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, July 27, 2015 7:52 AM
Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Wednesday, July 29, 2015 5:37 AM

Free Windows Admin Tool Kit Click here and download it now

July 20th, 2015 4:35am

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Thanks

July 27th, 2015 3:54am

Hi George,

Looking at your chart you will notice that ISO.CEILING and CEILING.PRECISE have exactly the same attributes. My question is why two functions with exactly the same functionality. That question remains outstanding.

Sincerely,

Shane

Free Windows Admin Tool Kit Click here and download it now

July 29th, 2015 9:01am

This topic is archived. No further replies will be accepted.