more complex if statement - How

[harty]

I have a simple question

If I have a price per item if people select it in a value list with radio buttons I want to assign a price to it to be placed in a calc field

for example

If the field fruit says "orange"

then place $.75 in field price

but

If the field fruit says "apple"

then place $.50 in field price

How can I do this the best way. thanks

Dave

[SteveB]

Use a Case statement:

Case( fruit= "apple", .75, fruit= "pear", .65, fruit= "orange", .50)

Steve

Edited February 25, 2006 by Guest