Forum Discussion
Confuse 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...
I like your use of a visual for the INDEX/MATCH aspect of the mystery formula.
But, Hans!, you missed the part where you're to take whatever value that INDEX/MATCH formula retrieves and multiply it by $B27.
=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))),""),"-")
Between the two of us, though, I think we did alright.
I'd still like to know what's actually IN those columns; what kind of information is being manipulate here? Currency, Inventory, .... ?
Thanks, John. I concentrated so hard on trying to explain the INDEX/MATCH combination that I forgot the multiplication.