| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF formula needed....
Hey guys this one works great but how do I add in the letters I am looking
for too? Like with this string I also need a 1 displayed if the letter a is displayed? =IF(ISNUMBER(G7),IF(TRUNC(G7)=G7,IF(AND(G7=1,G7<= 7),1,0),0),0) Any suggestions would be great! |
| 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
