Multiple If/Or Statements
 

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!

Multiple If/Or Statements
 

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)

"scolbert" wrote in message
...
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!

Multiple If/Or Statements
 

One way:

=INDEX(D1:F1,A1)

In article ,
scolbert wrote:

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!

Multiple If/Or Statements
 

Got it - trying to make it more difficult than it was - thanks!

"Bob Phillips" wrote:

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)

"scolbert" wrote in message
...
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!