Excel does not give you a choice. Here is my favorite Excel macro. Can you figure out what it does? :-)
=IF(DASHBOARD!$F$6=1,
IF(VLOOKUP($C10,IND.WORKSHEET!$C$6:$GS$208,152,FALSE)=DASHBOARD!$A$227,
(VLOOKUP($C10,IND.WORKSHEET!$C$6:$GS$208,153,FALSE)*
VLOOKUP($C10,IND.WORKSHEET!
$C$6:$GS$208,150,FALSE)*VLOOKUP(VLOOKUP($C10,IND.WORKSHEET!
$C$6:$GS$208,151,FALSE),ORG.WORKSHEET!$B$126:$Q$137,13,FALSE)*1000),0),
IF(VLOOKUP($C10,IND.WORKSHEET!$C$6:$GS$208,122,FALSE)=DASHBOARD!$A$227,
(VLOOKUP($C10,IND.WORKSHEET!$C$6:$GS$208,123,FALSE)*
VLOOKUP($C10,IND.WORKSHEET!
$C$6:$GS$208,120,FALSE)*VLOOKUP(VLOOKUP($C10,IND.WORKSHEET!
$C$6:$GS$208,121,FALSE),ORG.WORKSHEET!$B$126:$Q$137,13,FALSE)*1000),0))
Please, before any more down-votes, read my comment.