User Profile
Arsalan975
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Re: Confuse about formula
Arsalan975 @Hans Vogelaar mathetes Hi I took the screenshot of the fields from my file, can anyone please how the value in "27C" been calculated. Fomula: =IFERROR(IF(AND($B27>0,$B$20<=W$2,$B$21+$B$20>=W$1),$B27*(INDEX($S$7:$V$15,MATCH($A27,$R$7:$R$15,0),MATCH(C$26,$S$5:$V$5,0))),""),"-")1.9KViews0likes3CommentsConfuse about formula
Hi guys! can someone help please, I am trying to understand how the value is calculated in a particular cell. The formula is as below: =IFERROR(IF(AND($B27>0,$B$20<=W$2,$B$21+$B$20>=W$1),$B27*(INDEX($S$7:$V$15,MATCH($A27,$R$7:$R$15,0),MATCH(C$26,$S$5:$V$5,0))),""),"-") Can anyone elaborate to me please. Thanks2KViews0likes9Comments
Recent Blog Articles
No content to show