I am trying to do a calcuation that would be equivilent to an if; then statement

If number field A is less than or equal to 0, than the calculation field remains as a fixed number (Field but if number field A is greater than 0 than the calculation should take place which is (Field B + Field C)

I have only been able to get filemaker to do one or the other calculations but not both.

how do i do this?

thanks!

deborah

I am very new to building databases!

I believe this does what you are looking for.

If (Field A ≤ 0 ;1000 ;Field B + Field C )

If field A is 0 or less it will return 1000. Which you can make any number you want.

Michael

Edited July 5, 200718 yr by Guest

yes! that worked!

thank you so much!!