IF Statements 1

[scottpdann]

I created a formula comparing dates, divided it by 365, and it told me the year between the two dates. It is blank if there is no second date.

I need to create a formula where if this earlier # is >1.25 I want to list it as "former" , if it is greater than Zero, and 1.25 or less, it should say "Renew". If it is blank, then it should say "New".

Then, I need a totals formula to count the number in each group.

Any help would be appreciated. Thank you.

 

[lbass]

Are the dates you are comparing from the same or different fields? Please share your formula.

-LB

 

[scottpdann]

The date's are from the same field. I have the comparison down to a number. I need to get a formula based on the number.

 

[lyanch]

if isnull({@yourformula}) then "New"
else if {@yourformula} > 1.25 then "former"
else "Renew"

Lisa

 

[scottpdann]

That did it. The else if semantics threw me.

How can I then count each type?