As we have recently had releases of 2 great new calculation stacks, CalcStack by @willwood and Formula by @1LittleDesigner, which look very good but I am after a particular bit of functionality and wondered if there is a way to do it or it might be available in a future update.
I’m wondering if it is possible to use an IF type function, so that depending on a range stated in an input box a different calculation would be performed.
For example, a car rental business has a standard dailyrate for 1-4 days of hire which would simply be Daily Rate x Number of Days. However if you hire for more than 4 days you get a cheaper daily rate. So dependent on the number of days you hire for you would end up with a formula like this
Price = IF(Number of Days >5, Cheap Rate x Number of Days, Standard Rate x Number of Days)
Is there any way to achieve this as either stacks currently stand?
I couldn’t see any easy way to achieve this in the demo version of CalcStack.
Could there be a way to achieve this by using Siphon stack, which can handle logic?
If anyone has any advice it would be great, thank you