jarrodprice
asked on
Creating a conditional Field Calculation
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER