+ Reply to Thread
Results 1 to 4 of 4

Dividing number formula but require a minimum output?

  1. #1
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    Dividing number formula but require a minimum output?

    Hi, I think I have an easy question for someone out there. I have a very basic formula in B71. All it does is = B83/15/4. Then I formatted the cell B71 to fractions as halves ½. If the number in B82 is 15 or greater it works fine but 1 to 14 returns a zero.
    My question, how can I have that formula work but also add that the minimum output is ½? Zero in B83 is then 0 in B71.
    So if in B83 then in B71
    0 0
    1-14 ½
    15 or greater Actual

    Any help would be greatly appreciated.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,733

    Re: Dividing number formula but require a minimum output?

    Try this in B71:

    =IF(B83=0,0,IF(B83<15,0.5,B83/15/4))

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Dividing number formula but require a minimum output?

    Please Login or Register  to view this content.
    something like this????
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Dividing number formula but require a minimum output?

    Pete it worked Perfect, thank you. Pop I didn't try yours but thank you also for responding.

    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Require Cell To Contain Minimum Of '1' And Prevent Deletion
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-07-2012, 12:07 PM
  2. [SOLVED] Formula for dividing and rounding a number with multiples of 500
    By mojitomaster in forum Excel General
    Replies: 5
    Last Post: 05-14-2012, 07:11 AM
  3. Require formula to identify a number, not text
    By Fbs1960 in forum Excel General
    Replies: 3
    Last Post: 12-17-2011, 06:55 AM
  4. Is VBA possible on this output or does this require just a SUMIF formula?
    By geng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2010, 03:24 AM
  5. [SOLVED] What is the formula for dividing a number by 4 in excel
    By Blessingspoint in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2005, 02:06 PM

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