If loop help required

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.

Hi & welcome to the board.
Cell E50 divided by 2= 37468.667 which is greater than C156 hence it doesn't show 3%

Fluff said:

Hi & welcome to the board.
Cell E50 divided by 2= 37468.667 which is greater than C156 hence it doesn't show 3%

Click to expand...

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

Glad you sorted it & thanks for the feedback