SOLVED

Second IF statement

New Contributor

Andy_Kelly_0-1642852639259.png

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 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@Andy_Kelly 

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

that works a treat, thank you very much Hans!