# 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-Q11ANDIf Cell Q11=0 then it equal 0 See More: If Formula Question

#1 July 16, 2010 at 10:45:02

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-Q11ANDIf Cell Q11=0 then it equals 0ANDIf Cell Q11 is >40 it equals 0

Report •

#3
July 16, 2010 at 16:18:54

Report •

Related Solutions

#4 July 16, 2010 at 18:52:42
 If Cell Q11<40andIf Cell Q11=00 is less than 40......True?You need stricter criteria, or a more complete explanation of what you’re trying to do.MIKEhttp://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 • 