Tech Support banner

Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
25 Posts
Discussion Starter · #1 ·
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?
 

·
Registered
Joined
·
286 Posts
Taosd,

It's been a very long time since I've used Excel (This 2000 BTW) but, this seems to do the job.

Hope this works for you

:ufo:

twas
 

Attachments

1 - 3 of 3 Posts
Status
Not open for further replies.
Top