Most RecentMost ViewedMost LikesNeed help with formula I would like to build a formula that says: In M16 If the sum (F8:L13) > 40 then M17 = 40, If the sum (F8:L13) <or = 40 then M17 = F8:L13 Next: If M17 > 40 then M20 = Sum (F8:L13)-40, If M17 < or = 40 then M17 = 0
