Thread: If Statement
View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Sun, 18 Sep 2005 15:31:48 -0500, "Hank" wrote:

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