I want to have one of two results either the number is over 40 then show 40 if the number is less than 40 then show the number. the if statement is missing something because it is showing both numbers 40 and the number less than 40.
=IF(O4>$R$1,(O4-$R$1),40),IF(O4<$R$1,(C4+D4+E4+F4+G4+H4+I4),0)
Solved by B. H. in 28 mins