Forum Discussion
Formula with reference and "if"
I have a pretty simple sheet, which I would like to add a formula to, but I cannot find the right formula. Please see the attached test-sheet. I would like the sheet to automatically give a ...
In B19:
=$D$16*(100%-INDEX($G$5:$I$7,ROW($A19)-ROW($A$19)+1,MATCH($D$16,{0,50000,100000})))
Fill down to B21.