Condition based Formula calculation

[vishy86]

Hi,

I have a Program Year Age calculation (Calculated Column) based on a formula.

There is another column Single Risk Indicator which can only have 2 values viz. Y and N. I want the above formula for Program Year Age to be always calculated only for Single Risk Indicator = 'N'.

How do I implement this condition based formula.

Please show and help if possible. 

Thanks,

Vishy

[tex628 · Accepted solution]

You want to calculation Program Year Age to only occur if the Single Risk Indicator = 'N''?

If that is the case you need an IF statement:

IF( 
[Single Risk Indicator] = "N" , 
[Program Year Age] , 
BLANK()
)