Can i use nested if to call data for multiple conditions for following table: ex: I want to call incentives value 500 if sales target attainment is 70% -80% for selling Premium product, value 300 if it is middle segment and 100 if it is low segment. What is the recommended excel formula to apply in such case. SALES % Premium Product Middle Segment Low Segment 70% -80% 500 300 100 81% - 90% 1000 500 300 91%-100% 2000 1000 500
IF I pay attention AND I stay awake... I will learn!
AHHHHHHHHHHAAAAHH....exactly!
Boy Howdy!!! That was truly exciting!!
Can i use nested if to call data for multiple conditions for following table: ex: I want to call incentives value 500 if sales target attainment is 70% -80% for selling Premium product, value 300 if it is middle segment and 100 if it is low segment. What is the recommended excel formula to apply in such case.
SALES % Premium Product Middle Segment Low Segment
70% -80% 500 300 100
81% - 90% 1000 500 300
91%-100% 2000 1000 500