Try: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

[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 does not equal "N/A"

[Ron Rosenfeld]

On Sun, 18 Sep 2005 14:54:55 -0500, "Hank" <[email protected]> wrote:

>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