+ Reply to Thread
Results 1 to 3 of 3

Need =IF statement to give me decimal places for numbers less than 1 not 0

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    Charsleton, South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    2

    Lightbulb Need =IF statement to give me decimal places for numbers less than 1 not 0

    Hello everyone,

    I am trying to solve for how much months of supply for something but also want it to be broken down by either the first or second decimal so if its less than 1 it it will say .77 and as of now it displays 0. I would greatly appreicate the help. Thank you for your time. Cheers.

    =IF(BN5>=W5,IF(BN5>=W5+X5,IF(BN5>=W5+X5+Y5,IF(BN5>=W5+X5+Y5+Z5,IF(BN5>=W5+X5+Y5+Z5+AA5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5+AD5,IF(BN5>=W5+X5+Y5+Z5+AA5+AB5+AC5+AD5+AE5,9,8),7),6),5),4),3),2),1),0)

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need =IF statement to give me decimal places for numbers less than 1 not 0

    Hi and welcome to the forum.

    Have you tried formatting the cell to 2 decimal places?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-04-2013
    Location
    Charsleton, South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need =IF statement to give me decimal places for numbers less than 1 not 0

    Hi Richard,

    Thank you. Yes, I tired formatting the cell to two places and it comes out as 1.00 or 0.00.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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