| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formula to show "open" or "closed"
Hi,
I have been able to do a formula that provides a random number in a cell (C6). Upon entering a matching number in another cell (G6), I want to have a message ("closed") appear in yet another cell (A1) or if a non-matching number is entered the message in cell (A1) would be ("open"). Am new to formulas and have not been able to figure out what to do from the office help instructions. so far I have a non-working formula: =IF(g6=C6,"closed","open") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some formula results will not show up in the cell | Excel Worksheet Functions | |||
| conditional formatting with formula | Excel Worksheet Functions | |||
| Conditional Formatting formula not acceptable? | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Formula for conditional "ifs"? | New Users to Excel | |||
Threaded Mode
