On Mon, 24 Sep 2012 19:48:04 +0000, sarajmen wrote:

Spencer101;1605796 Wrote:
Try this in cell H3 and copy down.

=IF(B3=$L$1,$M$1,IF(B3=$L$2,$M$2,(E3*G3)+$H$2))

Is that what you mean?

Thanks for your help, I try to use your formula but something is wrong
with formula and wont work


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

Can you define what you mean by "won't work"?

Do you mean it gives the wrong values? If so, please provide the values
that are inputs (B3, L1, M1, L2, M2, E3, G3 and H2) and the expected and
actual outputs (H3).

Bruce