I need to enter a formula that returns more than two possible results like the "IF" formula. For example if cell E2's value is 'A' then I need cell G2 to return a certain formula such as (F2*.35). If E2 is 'B' then I need G2 to return a different formula and so on. Up to 7 different possible values for cell E2. Hope this makes sense.
Thanks for any suggestions.
This message was edited by saa38 on 2002-03-20 16:59
Thanks for any suggestions.
This message was edited by saa38 on 2002-03-20 16:59