If Then Logic

[RPB]

I want to do the following but have been have trouble.

IF A13=1, then G1=3, IF A13=2, then G1=6 and IF A13=3, then G1=9

Can anyone help????

 

[Gary''s Student]

In G3 enter:

=3*A13

 

[Mike H]

Hi,

Try this in g1

=CHOOSE(A13,3,6,9)

Mike

 

[Jacob Skaria]

Using IF() formula in G1
=IF(A13=1,3,IF(A13=2,6,IF(A13=3,9,"")))

Alternative solutions

=A13*3
OR
=CHOOSE(A13,3,6,9)


If this post helps click Yes

 

[RPB]

Thank you all. Most helpful.

Using IF() formula in G1
=IF(A13=1,3,IF(A13=2,6,IF(A13=3,9,"")))

Alternative solutions

=A13*3
OR
=CHOOSE(A13,3,6,9)


If this post helps click Yes

 

[Dana DeLouis]

Another option might be:

=IF(OR(A13={1,2,3}),A13*3,"")

= = =
HTH