Results 1 to 4 of 4

Thread: If loop help required

  1. #1
    Neophyte dm92's Avatar
    Join Date
    May 2019
    Posts
    2
    Articles
    0
    Excel Version
    2010

    If loop help required



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,

    Im a newby and looking for help on an example.

    I have set up an if statement that seems to be working for most of my cell entries except one. not sure why its not working but the value given out is "0" where is should be 3%.

    Please see attached the example sheet attached, Tab mdel 1- van, cell C104 (highlighted purple). the formula is in the cell but not working correctly, although working correctly on the others that i copied over.
    Attached Files Attached Files

  2. #2
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    74
    Articles
    0
    Excel Version
    2013
    Hi & welcome to the board.
    Cell E50 divided by 2= 37468.667 which is greater than C156 hence it doesn't show 3%

  3. #3
    Neophyte dm92's Avatar
    Join Date
    May 2019
    Posts
    2
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Fluff View Post
    Hi & welcome to the board.
    Cell E50 divided by 2= 37468.667 which is greater than C156 hence it doesn't show 3%

    Hi Fluff,

    Thanks... I see my error is a gap in my range... was meant to end at 44999 not 34999. What Happens when you work too late at night

  4. #4
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    74
    Articles
    0
    Excel Version
    2013
    Glad you sorted it & thanks for the feedback

Posting Permissions

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