| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
![Hank[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
