Previous Topic Next Topic

=IF(L9+M9>=40,10,) =IF(D8>=5,-40,) how do I make this work

[Closed]
Report
-
 RayH -
Hello,
=IF(L9+M9>=40,10,) =IF(D8>=5,-40,) how do I make this work?



1 reply

Answer 1 / 1 

=IF(L9+M9>=40,10,IF(D8>=5,-40,"X"))


I put "X" as I don't know what to use if neither condition is met.

You're Welcome!
Ask a question