| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting excel formula into module
Hi,
I am not quite familiar with writing custom function in module, could you help to convert the following excel formula? =IF(LEFT(J3,1)="1",IF(AW30,"dated on "&AQ3,IF(AO30,"waiting",INDEX($1:3,1,SMALL(IF(AR3 :AT30,COLUMN(AR3:AT3)),COLUMN(2:2)))))) Many thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
converting excel formula into module
Activecell = "=IF(LEFT(J3,1)=""1"",IF(AW30,""dated on " _ & " ""&AQ3,IF(AO30,""waiting"",INDEX($1:3,1,SMALL " _ & "(IF(AR3:AT30,COLUMN(AR3:AT3)),COLUMN(2:2)))) ))" -- Best wishes, Jim "BubbleGum" wrote: Hi, I am not quite familiar with writing custom function in module, could you help to convert the following excel formula? =IF(LEFT(J3,1)="1",IF(AW30,"dated on "&AQ3,IF(AO30,"waiting",INDEX($1:3,1,SMALL(IF(AR3 :AT30,COLUMN(AR3:AT3)),COLUMN(2:2)))))) Many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting a vba procedure/module to xml or xhtml? (vbhtmlmaker) | Excel Programming | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
| Converting Excel Formula to Macro | Excel Programming | |||
| Converting Excel Formula to Macro | Excel Programming | |||
Hybrid Mode
