Building Calculation with Nested IF Statement

[maiton.vang]

Hello below is my calculation:

If(Print Total < 20.00, Freight 2006 A B Total + 0.50, If(Print Total = "20.00" <> "40.00" , Freight 2006 A B Total + 3.00, If(Print Total > 40.00, Freight 2006 A B Total + 4.00, Freight 2006 A B Total + 4.00)))

What I'm trying to configure is:

1. If my Print Total is < 20.00 add 0.50 to my freight cost.

2. If my Print Total is >20.00 <40.00 add 3.00 to my freight cost.

3. If my Print Total is >40.00 add 4.00 to my freight cost.

Please help!

[mr_vodka]

Use a Case instead

Case ( Print Total ≤ 20; Freight 2006 A B Total + .5; Print Total < 40; Freight 2006 A B Total + 3; Freight 2006 A B Total + 4

)

[maiton.vang]

Thank you for the fast respond. When I copy and paste the formula i get a message indicate "This field cannot be found". I'm sorry its my fault i forgot to mention I am setting up the formula in pc filmaker pro 5.0.

Please Help!

[Ender]

Use commas instead of semicolons.

[Raybaudi]

... and may be that the Case function wasn't there !

If (

Print Total ≤ 20 , Freight 2006 A B Total + .5 ,

If (

Print Total < 40 , Freight 2006 A B Total + 3 ,

Freight 2006 A B Total + 4

)

)

[Lee Smith]

Hi Daniele,

I have used the Case Statement for as long as I can remember (getting to be less and less everyday, LOL), but I can only verify to version 4 right now, because I don't have older ones on this computer.

Tip to [color:orange]maiton,

I prefer the Case over the If because for me, it is easier to write and to read.

Lee

[comment]

Overall, this is not a good method. You should not hard-code your prices into calculation formulas, because prices tend to change over time. Use a lookup instead. Filemaker allows looking up a range ('if no exact match, copy next higher/lower').

[Raybaudi]

Lee, I too prefer the Case function

BTW: I said "may be", because I remember that there was some variation of the LOGICAL functions between 5 and 5.5

[maiton.vang]

AWESOME!!!

It work!

THANK YOU EVERYONE FOR YOUR HELP

[mr_vodka]

Why did the orig post state it was FM8?

[Raybaudi]

maiton, read carefully what comment said to you :)

[maiton.vang]

sorry for the confusion i have FM5.0 on my PC and FM8.0 on my mac.