Greater than and Less than

[hcabs99]

Hi all

Some advise please.

I have a program set up which generates a sequential list of times , the gap between each time is set by a users entered value. All of that works fine, but what i need Excel to do, is to increment the date whenever we go past midnight. So , i have built this formula which works fine if the user has selected hourly intervals, but if they select half hours (for example), it doe not calculate correctly.

To get round this, i need the formula below to work with a greater than 2 and less than 3 (for example)

=IF(I13>1;1)+IF(I13<2;1)+IF(I13=2;2)+IF(I13=3;3)+IF(I13=3.99999999901047;4)+IF(I13=5;5)+IF(I13=6;6)+IF(I13=7;7)

I'm sure its possible, but i get errors everytime i do it.

Note..I have changed my regional settings to use ; instead of , in case this confuses anyone!

 

[MrKowz]

Try:

=LOOKUP(I13,{1,2,3,4,5,6,7})

 

[Scott Huish]

How about:

=INT(I13)

 

[hcabs99]

How about:

=INT(I13)

Yep, spot on, i was making this way too complicated!!

ta