• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    =IF statement: formatted into two decimals instead just whole numbers

    Sorry here it is. Thanks http://ge.tt/6bpUBCa/v/0
  2. G

    =IF statement: formatted into two decimals instead just whole numbers

    https://www.rapidshare.com/#myrs_filemanager/file/0
  3. G

    =IF statement: formatted into two decimals instead just whole numbers

    Hi Luke, I tried to use the ` methodology to add the data here but doesnt come over cleanly. Its okay, I'll try a different forum. Thank you for your time. I really appreciate it.
  4. G

    =IF statement: formatted into two decimals instead just whole numbers

    How can I post a portion of my spread sheet here. Thank you for your help.
  5. G

    =IF statement: formatted into two decimals instead just whole numbers

    I will mimic it here. A B C D E F H Forecast POS Retailer EI Inventory Number of months supply March April May June July As of March 4 Forumula =IF(F:3>B3,if(F:3>B3+C3.. 14 24 34 56 23...
  6. G

    =IF statement: formatted into two decimals instead just whole numbers

    Hi Luke M, I tried that but no sure if my data would work using the =sum(W:5:W5) since I have so many rows. Enclosed is a screen shot of some of the data. Thanks. And the new formula of the beginning row. Thanks again...
  7. G

    =IF statement: formatted into two decimals instead just whole numbers

    Hi Narayan, Think of it like this =IF(inventory>POS March but not greater than POS April there will be a remainder. Right now the remainder is dropped to 0. Thanks.
  8. G

    =IF statement: formatted into two decimals instead just whole numbers

    I tired formatting the cell to two places and it comes out as 1.00 or 0.00.
  9. G

    =IF statement: formatted into two decimals instead just whole numbers

    Hello Chandoo Community, I am a long time reader, first time poster and was a student of the Chandoo Dashboards class. I am trying to solve for how much months of supply for a product a retailer but also want it to be broken down by either the first or second decimal so if its less than 1 it...
Back
Top