| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF formula needed....
I need a formula that will look at one cell G7 and if it is a 1, 2,3, 4, 5,
6, 7, or a then I need it to display a 1. The formula I am using is this: =IF(G7="1","1",IF(G7="2","1",IF(G7="3","1",IF(G7=" 4","1",IF(G7="5","1",IF(G7="6","1",IF(G7="A","1"," 0"))))))) All the cells are formatted as general text. The formula is working when it sees "a" but not any of the numbers? Any ideas on how I can make the whole thing work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| steps needed for freezing headers when using multiple pages | Excel Discussion (Misc queries) | |||
| Help needed replacing multiple cells from a list of values. | Excel Discussion (Misc queries) | |||
| Multiple Task needed in Excel | Excel Discussion (Misc queries) | |||
| Multiple Condition Help needed.... | Excel Worksheet Functions | |||
| Multiple condition help needed | Excel Worksheet Functions | |||
Threaded Mode
