Hello, =IF(L9+M9>=40,10,) =IF(D8>=5,-40,) how do I make this work? Configuration: Windows 7 / Firefox 42.0

Previous Topic Next Topic

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

Closed

Russ - Nov 17, 2015 at 01:59 PM
RayH - Nov 17, 2015 at 02:52 PM

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

Answer 1 / 1

RayH
Nov 17, 2015 at 02:52 PM

=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!