Results 1 to 12 of 12

Ceiling function help

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2008
    Posts
    16

    Ceiling function help

    Hi All,

    I am currently using the formula below to calculate 10% of a total, it rounds up to the nearest whole number to ensure that at least one spare part is supplied.

    =CEILING((F193*0.1),1)

    Is there a way to change this to give an output of 3 as a minimum or 10%? Currently if I input 8 the calculation gives me a result of 1, if I input 30 I get a result of 3. I need to ensure that the result is at least 3.

    thanks for your help
    Last edited by danjstock; 04-20-2010 at 09:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1