### Title

Using different formula's

### Post

I have a formula setup for all my records and would like to know if its possible to apply a different formula to specific records.

I am just using a single database and would like some records to one formula and other records a different formula.

(If this makes sense)

Thanks

jack

Howdy jackdash,

On the face of it, it looks like you need an "If" or "Case" statement.

What about the record would make you want to choose one formula or another? A date range? A number value? Some other marking field?

Your formula would thus turn into the form of:

If (

criteria met for using formula1; "Formula1" ; "Formula2" )We can help with the formula, but you'll have to give more info...