If Formula Question

Microsoft Excel 2010
July 16, 2010 at 10:31:15
Specs: Windows 7
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


See More: If Formula Question

Report •

#1
July 16, 2010 at 10:45:02
Say please.

Report •

#2
July 16, 2010 at 16:17:28
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


Report •

#3
July 16, 2010 at 16:18:54
PLEASE with sugar on top!!!

Report •

Related Solutions

#4
July 16, 2010 at 18:52:42
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

http://www.skeptic.com/


Report •

#5
July 16, 2010 at 19:50:41
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)


Report •

#6
July 18, 2010 at 13:52:28
Derby Dad you ROCK!! Thanks so much!!!

Report •

Ask Question