Forum Discussion
LisaMarie1981
Dec 01, 2022Brass Contributor
IF AND OR THEN ???
Hi there! I have to create a formula in cell B13 based on several criteria and I can't get past this first part. Start of formula is this: =IF(AND(B11>=B2),(B11<C2),B12="Good")*(B11*(100%+B3))...
- Dec 01, 2022
=($B$11*(100%+INDEX($B$3:$E$5,MATCH($B$12,$A$3:$A$5,0),MATCH($B$11,$B$2:$E$2,1))))
Does this return your expected result?
LisaMarie1981
Dec 01, 2022Brass Contributor
I have version 2210
mathetes
Dec 01, 2022Silver Contributor