ExcelBanter - converting excel formula into module

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - converting excel formula into module (https://www.excelbanter.com/excel-programming/378259-converting-excel-formula-into-module.html)

BubbleGum

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.

Jim Jackson

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.

All times are GMT +1. The time now is 05:28 PM.