inglestadt
New Member
- Joined
- Sep 13, 2006
- Messages
- 5
This is hard for me to explain. But here it goes.
A1=Widget1
A2=Left Handed
A3=Red
A4=Mod2
A5=PriceLevel2
A6=Unit Price
A1 through A5 you can select various options (e.g. A1 could Equal any one of the following: Widget1, Widget2, Widget3 or Widget4)
Trying to right a formula where a value could automatically be entered in A6 based on which values are in A1 to A5.
Example 1: A6=$500 if (A1=Widget1, A2=Left Handed, A3=Red, A4=Mod2, 5=PriceLevel2).
A6 would = $400 if ((A1=Widget3, A2=Right Handed, A3=White, A4=Mod2, 5=PriceLevel4).
Any suggestions.
A1=Widget1
A2=Left Handed
A3=Red
A4=Mod2
A5=PriceLevel2
A6=Unit Price
A1 through A5 you can select various options (e.g. A1 could Equal any one of the following: Widget1, Widget2, Widget3 or Widget4)
Trying to right a formula where a value could automatically be entered in A6 based on which values are in A1 to A5.
Example 1: A6=$500 if (A1=Widget1, A2=Left Handed, A3=Red, A4=Mod2, 5=PriceLevel2).
A6 would = $400 if ((A1=Widget3, A2=Right Handed, A3=White, A4=Mod2, 5=PriceLevel4).
Any suggestions.