Formula field - anyway to round up/down to nearest integer?

Formula field - anyway to round up/down to nearest integer?

Hi all

I'm sure I'm missing something, but how can I return the nearest integer i.e. 5.2 = 5, 5.7 = 6?

Ceil and Floor round up or down... not to the nearest.

Thanks

BUMP

Any ideas on this? This cannot be too difficult surely?

Just to clarify, this is what I need to do:  http://en.wikipedia.org/wiki/Nearest_integer_function

BUMP!! If this isn't possible - please let me know?

            Zoho DataPrep Resources


                Zoho CRM Plus Resources

                  Zoho Books Resources


                    Zoho Subscriptions Resources

                      Zoho Desk Resources

                        Zoho Projects Resources


                          Zoho Sprints Resources


                            Zoho Orchestly Resources


                              Zoho Creator Resources


                                Zoho WorkDrive Resources




                                    Zoho Campaigns Resources

                                      Zoho CRM Resources

                                                  Design. Discuss. Deliver.

                                                  Create visually engaging stories with Zoho Show.

                                                  Get Started Now




                                                      Zoho Writer Writer

                                                      Get Started. Write Away!

                                                      Writer is a powerful online word processor, designed for collaborative work.