Narendrareddy
New Member
- Joined
- Mar 21, 2015
- Messages
- 17
How to write this excel funtion in VBA Script.
Function: =IF(SUMIFS(Data!$F$3:$F$21000,Data!$A$3:$A$21000,"<="&D$21,Data!$B$3:$B$21000,">"&D$21,Data!$C$3:$C$21000,$C5,Data!$D$3:$D$21000,"LHS")=0,"",IF(SUMIFS(Data!$F$3:$F$21000,Data!$A$3:$A$21000,"<="&D$21,Data!$B$3:$B$21000,">"&D$21,Data!$C$3:$C$21000,$C5,Data!$D$3:$D$21000,"LHS")<50000,SUMIFS(Data!$E$3:$E$21000,Data!$A$3:$A$21000,"<="&D$21,Data!$B$3:$B$21000,">"&D$21,Data!$C$3:$C$21000,$C5,Data!$D$3:$D$21000,"LHS")&"/"&TEXT(SUMIFS(Data!$F$3:$F$21000,Data!$A$3:$A$21000,"<="&D$21,Data!$B$3:$B$21000,">"&D$21,Data!$C$3:$C$21000,$C5,Data!$D$3:$D$21000,"LHS"),"dd-mm-yyyy"),"Laps"))
Function: =IF(SUMIFS(Data!$F$3:$F$21000,Data!$A$3:$A$21000,"<="&D$21,Data!$B$3:$B$21000,">"&D$21,Data!$C$3:$C$21000,$C5,Data!$D$3:$D$21000,"LHS")=0,"",IF(SUMIFS(Data!$F$3:$F$21000,Data!$A$3:$A$21000,"<="&D$21,Data!$B$3:$B$21000,">"&D$21,Data!$C$3:$C$21000,$C5,Data!$D$3:$D$21000,"LHS")<50000,SUMIFS(Data!$E$3:$E$21000,Data!$A$3:$A$21000,"<="&D$21,Data!$B$3:$B$21000,">"&D$21,Data!$C$3:$C$21000,$C5,Data!$D$3:$D$21000,"LHS")&"/"&TEXT(SUMIFS(Data!$F$3:$F$21000,Data!$A$3:$A$21000,"<="&D$21,Data!$B$3:$B$21000,">"&D$21,Data!$C$3:$C$21000,$C5,Data!$D$3:$D$21000,"LHS"),"dd-mm-yyyy"),"Laps"))