Microsoft Excel 2010

What is the formula to use if you want the following calculation: If Cell Q11<40 then it equals 40-Q11

AND

If Cell Q11=0 then it equal 0

Say please.

I forgot to add the following criteria it should read as follows: If Cell Q11<40 then it equals 40-Q11

AND

If Cell Q11=0 then it equals 0

AND

If Cell Q11 is >40 it equals 0

PLEASE with sugar on top!!!

If Cell Q11<40 and

If Cell Q11=0

0 is less than 40......True?

You need stricter criteria, or a more complete explanation of what youâ€™re trying to do.

MIKE

While Mike is correct in saying that 0 is less than 40, I'll assume that you are treating 0 as a special case. Try this:

=IF(OR(Q11=0,Q11>40), 0, 40-Q11)

Derby Dad you ROCK!! Thanks so much!!!

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History