IF statement
 

How can I get the following done in Excel 2000:

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


Thanks

IF statement
 

On Sun, 18 Sep 2005 14:54:55 -0500, "Hank" 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

IF statement
 

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

--
Cutte
-----------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...nfo&userid=984
View this thread: http://www.excelforum.com/showthread.php?threadid=46864