Formula with two conditions

[AndeanWayne]

I have a query which is the data source for a report. To find the correct number of penalty periods the formula is penalties([RedemptionDate]-[CertificationDate])/182.5)+1 which is fine if there is a redemption date. It give an initial penalty then another penalty each half year. But if there is no redemption date the formula needs to be: ((Now()-[CertificationDate])/182.5)+1
Is there a way to roll this into one formula so if there is a redemption date (not null) it uses the first formula and if there is no redemption date it uses the second formula?

 

[plog]

Yes, but don't think of it as 2 formulas. Think of it as 1 formula that a default for [RedemtionDate]. Check out the NZ function (http://www.techonthenet.com/access/functions/advanced/nz.php).

If [RedemptionDate] is null use Now, if not, use [RedemtionDate]. Give it a shot and post back here if you have questions.

 

[AndeanWayne]

So assuming my one formula is:
penalties=([RedemptionDate]-[CertificationDate])/182.5)+1
where does the following go?:
If [RedemptionDate] is null use Now, if not, use [RedemtionDate] to trigger using the Redemption Date or Now()

 

[plog]

You put it where [RedemptionDate] date is located.