bankerlady
Board Regular
- Joined
- Feb 24, 2006
- Messages
- 73
I need help with a formula today:
I have four columns, A through D, headings Threshold, Target, Stretch and Actual.
I have a goal in the threshold, target and stretch columns and an actual production result in the actual. Let's assume these numbers are on row 3.
In column E I want it to display a value as follows:
If D3=>A3,10 **this part of the formula works great, it's the additional qualifiers that I can't get right, probably a punctuation or parenthesis error on my part.
Or if D3=>B3,40 or if D3=>C3,75, otherwise 0.
Any help on how to structure this formula ??
Thanks so much, this board is great!!!
I have four columns, A through D, headings Threshold, Target, Stretch and Actual.
I have a goal in the threshold, target and stretch columns and an actual production result in the actual. Let's assume these numbers are on row 3.
In column E I want it to display a value as follows:
If D3=>A3,10 **this part of the formula works great, it's the additional qualifiers that I can't get right, probably a punctuation or parenthesis error on my part.
Or if D3=>B3,40 or if D3=>C3,75, otherwise 0.
Any help on how to structure this formula ??
Thanks so much, this board is great!!!