Good Evening

I am trying to enter what I feel is a rather simple “IF” statement but I can’t figure it out.

I have a Field titled “Item Type” and one titled “FLW – Business Days Remaining” and want to return a “2” if the Item Type equal “Prospect” and “FLW – Business Days Remaining” is grater than 2.

This is what I have

=IF(AND([Item Type]=”Prospect”,[FLW – Business Days Remaining] >2,”2″)))

Any help would be greatly appreciated

​Good EveningI am trying to enter what I feel is a rather simple “IF” statement but I can’t figure it out. I have a Field titled “Item Type” and one titled “FLW – Business Days Remaining” and want to return a “2” if the Item Type equal “Prospect” and “FLW – Business Days Remaining” is grater than 2. This is what I have=IF(AND([Item Type]=”Prospect”,[FLW – Business Days Remaining] >2,”2″))) Any help would be greatly appreciated  Read More

​