| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If-format problem
Hi, i have this code that retrieve : Rate 1, or Rate 2.....from E6:Q6 if
there is something in E8:Q8. The code is working ok, if in E8:Q8 is something like this(584.01.10.2009). I need this code to work if in E8:Q8 is something like this (584/01.10.2009) =IF(rate!E8="",rate!E6,IF(INDEX(rate!E6:Q6,MATCH(9 ^9,rate!E8:Q8)+1)="","No more rates",INDEX(rate!E6:Q6,MATCH(9^9,rate!E8:Q8)+1))) Can this be done? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Format Problem - Date Overrides Format | Excel Discussion (Misc queries) | |||
| General Format to Custom format problem | Excel Discussion (Misc queries) | |||
| if format problem | Excel Worksheet Functions | |||
| Format Problem | Excel Discussion (Misc queries) | |||
| Format problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
