I want to create a field calculation.
Field A "Category" is a text field
Field B "Retail Price" is a number field
Field C "Minimum Price" is a calculation field.
I want the calculation in Field C to change depending on the field contents of Field A. Here are the condtions:
1) When Field A is "standard", Field C is 75% of Field B.
2) When Field A is "fixed", Field C is 100% of Field B
3) When Field A is "no reserve", Field C is 25% of Field B
How do I write the calculation in Field C to meet these 3 conditions?