AnsweredAssumed Answered

IF Function

Question asked by LarryMastromatteo on Aug 18, 2011
Latest reply on Aug 19, 2011 by LarryMastromatteo

Title

IF Function

Post

Hello:

 

I am having a problem with the if function. I recently upgraded from FM 5.5 to FM 11 and what work in FM5.5 does not seem to work in FM11. I am having a problem with an if function. The formula is:

CheckNumberCalculator:

If(Cheque # = 0 and Second Cheque #  = 0 and Third Cheque #   = 0, Empty,
If(Cheque # > 0 and Second Cheque #  = 0 and Third Cheque #   =0,Cheque #,
If(Cheque # > 0 and Second Cheque #  > 0 and Third Cheque #   = 0,Second Cheque #,
If(Cheque # > 0 and Second Cheque #  > 0 and Third Cheque #   > 0,Third Cheque #,Empty ))))

 

In FM 5.5 this works but in FM 11 if I put a number in the Check # box the CheckNumberCalculator is empty not until all three boxes have a number that the CheckNumberCalculator brings back the last number.

 

I would appriciate any help with this! Thank you!

 

 

 

Outcomes