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