Thread: converting excel formula into module
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BubbleGum BubbleGum is offline
external usenet poster
  
Posts: 2
Default 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.
Reply With QuoteReply With Quote