Need some help. I am trying to use an if statement with a calculation in a repeating field that looks at a non-repeating field with the extend function.

If(LH1 >= Extend(HEEL) and LH1 <= Extend(IHEEL) ," ","** **")

This works perfectly except when there is no entry in the first cell of the LH1 field. It returns the ** **. If I make an entry then it works perfectly All other repetitions in the repeating field work fine. Any way to fix the first cell? I've tested both clicking and unclicking the " Do not evaluate if all referenced cells are empty"

Something to keep in mind with FileMaker Pro: A number field can be expressed as a Boolean. A Boolean value is either true or false, and is often used to test the condition of something. A zero or null value in a number field is treated as false in the Boolean sense; any other data is treated as true.

This means that Filemakers implementation is slightly off theory!

--sd