If Then Logic
 

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????

If Then Logic
 

In G3 enter:

=3*A13
--
Gary''s Student - gsnu200859


"RPB" wrote:

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????

If Then Logic
 

Hi,

Try this in g1

=CHOOSE(A13,3,6,9)

Mike


"RPB" wrote:

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????

If Then Logic
 

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
---------------
Jacob Skaria


"RPB" wrote:

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????

If Then Logic
 

Thank you all. Most helpful.

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"RPB" wrote:

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????

If Then Logic
 

Another option might be:

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

= = =
HTH

RPB wrote:
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????