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...
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))),""),"-")
Arsalan975 I’m on my phone at the moment, with its limited keyboard, so not about to attempt a full explanation. But if you read through the responses you’ve already gotten, replacing the abstract cell references with the content from the various cells, you should be able to figure it out.
If you haven’t by the time I get to a desktop, I’ll chime in again.