IF statement

[Hank]

How can I get the following done in Excel 2000:

If cell G9 = "N/A" then cell G10 and G11 also = "N/A"


Thanks

 

[Ron Rosenfeld]

How can I get the following done in Excel 2000:

If cell G9 = "N/A" then cell G10 and G11 also = "N/A"


Thanks

See answer in .misc

There is little point in multi-posting.
--ron

 

[Cutter]

Place the same formula in G10 and G11

=IF(G9="N/A",G9,"whatever")

Substitute the "whatever" with the value you want showing if G9 doe
not equal "N/A