If then, adding more choices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
You have too many parenthesis.
=IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3))))
 
This seems to work:
=IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3))))

Ie, you dont use a closing bracket after each if argument, you just put a
closing bracket for each if argument at the end of the formula


Philip
 
Thank you so much!!

Philip Reece-Heal said:
This seems to work:
=IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3))))

Ie, you dont use a closing bracket after each if argument, you just put a
closing bracket for each if argument at the end of the formula


Philip
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recorded macro selection widened 4
Match statement that displays result 1
If statement to add picture based on cell value 2
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Formula Help Needed (Sum and If Then) 1
Compare Col A and Col M, if Match, Copy Col N to Col E 6
Excel Named Formula Weakly Interacts with a Variable Range on the Worksheet - Re-Visit 5

Back
Top