You are viewing limited content. For full access, please sign in.

Question

Question

Forms calculation - combine two IF formulas

asked on November 23

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 Show version history

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.

Sign in to reply to this post.