### Title

VLookUp a value in a range of data in a Table

### Post

In MS Access, I had a table that enable me to round up chargeable time to the nearest quarter of an hour. The minimum charge was 1 hour and this incremented in 15 minute chunks of time.

MinutesFrom | MinutesTo | HoursToCharge

1 60 1

61 75 1.25

76 90 1.5

91 105 1.75

Etc.

What is the best way to achieve the above in FM, is there a better way?

Thanks

Brian.

Try using this function, where you send the minutes as a parameter:

Let ( [ m = minutes ] ;

If ( M < 61 ; 1 ; Ceiling ( m / 15 ) / 4 )

)