Jon_AK
New Member
Am having a bit of a time creating a non-VBA method with this particular problem: When equipment is rented, it is rented by the day, 5 day week or 20 day month. The break point is 1 or 2 days for day rate, 3 - 10 consecutive days for weekly rate & greater than 10 consecutive days for monthly rate. The complication comes when having to accomodate extra days at day rate when either the weekly rate or monthly rate is in effect and/or accomodate extra days or extra weeks when the monthly rate is in effect. Currently I have a way long set of nested if-else statements using MOD(), INT(), ROUND() functions which only works part way. Example, rental for 27 days equals one 20 day month, one 5 day week and 2 days. Cannot seem to get it together so that the formula for this scenerio will work for any given amount of rental days.