Second IF statement

[Andy_Kelly]

Keeping the original formula in the Minimum Hours column (shown in the input bar). I need to reduce the Minimum Hours by 30% if 'Yes' is selected in the Retrain column. Is that possible? 

[#2 · Accepted solution]

@Andy_Kelly 

=IF($F3="","",VLOOKUP($F3,'Sign Off Hours'!$A:$B,2)*IF($I3="Yes",0.7,1))

[#3]

that works a treat, thank you very much Hans!