Multiple If/Or Statements

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

Guest

Need a formula to evaulate (If CellA = 1, Then enter value in CellD), OR (If
CellA = 2, Then enter value in CellE), OR (If CellA = 3, Then enter value in
CellF). Any/all assistance is greatly appreciated!
 
If just those conditions then

=IF(A2=1,D2,IF(A2=2,E2,IF(A2=3,F2,"")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
You must log in or register to reply here.

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

Modify a Macro 1
If function - Add if its blank, to return blank 1
Naming of tabs from data in a worksheet 2
How do I install a UDF? 6
IF Function 3
Activecell problem 1
Random Numbers 6
macro to copy down the values while the adjacent cell be NOT empty 1

Back
Top