If Statement

[Hank]

How can I get this done:

IF G9="N/A", then G10 and G11="N/A" ?

Thanks

 

[Ron Rosenfeld]

How can I get this done:

IF G9="N/A", then G10 and G11="N/A" ?

Thanks

G10: =G9
G11: =G9

or

G10: =IF(ISNA(G9),NA(),"something else")
G11: =IF(ISNA(G9),NA(),"something else")


--ron