ExcelBanter - If Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Statement (https://www.excelbanter.com/excel-discussion-misc-queries/45977-if-statement.html)

Hank

If Statement

How can I get this done:

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

Thanks

Ron Rosenfeld

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

All times are GMT +1. The time now is 09:45 PM.