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 manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History