Ok, I have this spread sheet. Let me set it all up for you.
In cells G6 - G68 there is a MINIMUM value
In cells I6 - I68 there MAXIMUM value
There is a formula in the cells H6 - H68 that is as follows :
=IF(G6>=I6/3,ROUNDDOWN(I6/3,0),ROUNDUP(I6/3,0))
This says that If the value in cell (G6 - G68) is more than the 1/3 the value in cell (I6 - I68)then Round the value of (G6 - G68) up. If it is less than 1/3 the value of (I6 - I68) then round down. This works grand for most of my data, except for when the value of (I6 - I68) is two. If the value is two, then the number that appears in the cell (H6 - H68) is 0. This cannot happen, The only time I want 0 is when the value of (I6 - I68) is 1. Can anyone modify my formula to make this possible?
In cells G6 - G68 there is a MINIMUM value
In cells I6 - I68 there MAXIMUM value
There is a formula in the cells H6 - H68 that is as follows :
=IF(G6>=I6/3,ROUNDDOWN(I6/3,0),ROUNDUP(I6/3,0))
This says that If the value in cell (G6 - G68) is more than the 1/3 the value in cell (I6 - I68)then Round the value of (G6 - G68) up. If it is less than 1/3 the value of (I6 - I68) then round down. This works grand for most of my data, except for when the value of (I6 - I68) is two. If the value is two, then the number that appears in the cell (H6 - H68) is 0. This cannot happen, The only time I want 0 is when the value of (I6 - I68) is 1. Can anyone modify my formula to make this possible?