# Question

### Forms calculation - combine two IF formulas

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)

0 0

# Replies

replied on November 23

You want to nest the IF formulas inside one another so that one of the values for the first if is the result of the second if like

IF(Condition1,TRUE,IF(Condition2,TRUE,FALSE))

For example

IF(Application<CutOff,100,IF(Application>Expire,1000,650))

Which effectively works out to be

If Application Date before Cut Off

Then 100

Else

If Application Date after Expiry Date

Then 1000

Else 650

If a value is not before the cut off or after the expiry, then it must be between them so you only need the two conditions.

1 0
You are not allowed to follow up in this post.