maybe like this:

=IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3))))


--
Hope that helps.

Vergel Adriano


"sandygiz" wrote:

I am using the following command to direct what happens in column of cells:
=IF(A6=1, E6*D3, IF(A6=2, E6*E3))

This works fine for 2 options, but when I try to add a 3rd & 4th, I get an
error.
=IF(A6=1, E6*D3, IF(A6=2, E6*E3), IF(A6=3, E6*F3), IF(A6=4, E6*G3))))
How do I add more options? I know my parenthesis and probably more are off.

Thanks!