I need to add an if blank into this formula. I am trying to add but I keep receiving an error. I am adding for a type of override to the current setup.
Current formula
=IF($BG$3<>0,IF($I6="Other - Explain in Comments",((AF6-$AC6)/$AC6)*R6,IF(AR6>0,((R6*AR6*((AF6-$BB6)/$BB6))+(((VLOOKUP($C6,'Market Input'!$G:$AX,BG$1,FALSE)-$BB6)/$BB6)*R6*(1-AR6))),((VLOOKUP($C6,'Market Input'!$G:$AX,BG$1,FALSE)-$BB6)/$BB6)*R6)),0)
want to add
IF cell BC is blank = 0 do nothing, but if a % is in cell BC (BC*AF)
Current formula
=IF($BG$3<>0,IF($I6="Other - Explain in Comments",((AF6-$AC6)/$AC6)*R6,IF(AR6>0,((R6*AR6*((AF6-$BB6)/$BB6))+(((VLOOKUP($C6,'Market Input'!$G:$AX,BG$1,FALSE)-$BB6)/$BB6)*R6*(1-AR6))),((VLOOKUP($C6,'Market Input'!$G:$AX,BG$1,FALSE)-$BB6)/$BB6)*R6)),0)
want to add
IF cell BC is blank = 0 do nothing, but if a % is in cell BC (BC*AF)