Forum Discussion

KatherinePhung's avatar
KatherinePhung
Qrew Trainee
8 years ago

How to create 'If' function in formula-number?

Hi, I need help. I'm putting together a formula:  If [Rem15 Preliminary # of Stories] is not null, [Confirmed Stories] field is equal to the value in [Rem15 Preliminary # of Stories].  If [Rem15 P...
App builders
Formulas and functions
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Lets simplify it to:

If(IsNull([Rem15  Preliminary # of Stories]), [REM 14 Projected Stories],  [Rem15  Preliminary # of Stories])
KatherinePhung's avatar
KatherinePhung
Qrew Trainee
8 years ago
Thanks Matthew!