Excel and IF Statements

Microsoft Excel 2003 (full product)
May 27, 2010 at 08:11:03
Specs: Windows XP
Can someone help me with this formula.

The statement works for the first part of the IF statement and displayes PM100, but not for the second... it only displays TRUE.

=IF(IF('Master Project Data - INPUTS'!I3>=Sheet3!B1,1,0)+IF('Master Project Data - INPUTS'!I3<=Sheet3!C1,1,0)=2,"PM100",IF('Master Project Data - INPUTS'!K3>=Sheet3!B1,1,0)+IF('Master Project Data - INPUTS'!K3<=Sheet3!C1,1,0)=2)

I want it to display PM300, but I get an error when I try to add it to the formula.


See More: Excel and IF Statements

Report •


#1
May 27, 2010 at 08:46:49
It appears that your missing an IF statement after the "PM100"

Try this:
=IF(
IF('Master Project Data - INPUTS'!I3>=Sheet3!B1,1,0)
+
IF('Master Project Data - INPUTS'!I3<=Sheet3!C1,1,0)=2,"PM100",

IF(
IF('Master Project Data - INPUTS'!K3>=Sheet3!B1,1,0)
+
IF('Master Project Data - INPUTS'!K3<=Sheet3!C1,1,0)=2,”PM300”,"")

MIKE

http://www.skeptic.com/


Report •

#2
May 27, 2010 at 09:19:06
Thanks for the quick response... but still something not right. When I paste the formula in and hit enter, the "PM300" is highlighted in Black. it does not like the value_if_true part of that formula.

Report •

#3
May 27, 2010 at 09:24:54
Check the quotes around PM300. In Mike's response they look different than "normal quotes" and Excel appears to be looking at them differently.

After pasting the formula in the cell, retype "PM300" and see what happens.


Report •

Related Solutions

#4
May 27, 2010 at 09:25:33
It does work... i pasted it incorrectly.... Thanks !

Report •

#5
May 27, 2010 at 09:35:53
Nice catch DerbyDad03 on the quote marks, I was using Word to break apart the formula, not Excel.

MIKE

http://www.skeptic.com/


Report •

#6
May 27, 2010 at 10:23:55
Why not just break it apart here in the forum?


Report •

#7
May 27, 2010 at 10:44:19
Old habits die-hard, I'm more accustomed to forming my replies Off-Line and then posting.
Back in my Compuserve days you paid by the minute for the amount of time spent on-line, was cheaper to form your replies off-line.

MIKE

http://www.skeptic.com/


Report •

#8
May 27, 2010 at 11:05:44
re: Back in my Compuserve days you paid by the minute...

Back before that we wrote letters to each other with quill pens and parchment.

It's time to move on!


Report •

#9
May 27, 2010 at 11:39:49
You had parchment!!
All I can remember is Papyrus......

MIKE

http://www.skeptic.com/


Report •

#10
May 27, 2010 at 11:52:35
But we had to write uphill...both ways.

Report •

#11
May 27, 2010 at 12:13:55
In a snow storm.....

MIKE

http://www.skeptic.com/


Report •

Ask Question