-2
I was looking for some help on writing some code for a nested if/and statements in a formula
IF(AND($AP12>=Zones!$B$18,Simulation!$AP12<=Zones!$B$20,Oven!$C$49=Oven!$D$49),(Simulation!Y12+Simulation!$BL$13)*Oven!$S$4,IF(AND($AP12>=Zones!$B$18,Simulation!$AP12<=Zones!$B$20,Oven!$C$49="Convect...