I'm trying to combine two IF formulas in a form calculation and am not sure how to do this. This is all based on three different dates: 1) expiry date, 2) cut off date, and 3) application date and must follow the following rules:
If the Application Date is before the Cut Off Date the cost is $100
If the Application Date is between the Cut Off Date and Expiry Date the cost is $650
If the Application Date is after the Expiry Date the cost is $1000
I've come up with the following formulas and they work individually, but how do i combine them?
=IF(Expire<CutOff, 550, 0)
=IF(Expire<Application, 1000, 550)