Excel 2007 : using apostrophes in =IF( formula

**chop924** · 04-11-2012, 02:45 PM

Maybe I am not using the IF function right, but its a fairly simple formula and I'm not sure why its not working.

I have a list of construction projects that are rated under a certain code, the "success" of this code being a percentage (usually between 15 and 85%). I have a long list of projects and am trying to list all of the square footage for the projects with a code percentage greater than 60.0%.

I tried this originally:

=IF([cell containing percentage]>"60.0%",[cell containing square footage],0)

Any ideas? Thanks!

**DGagnon** · 04-11-2012, 02:46 PM

Try doing it like this

=IF([cell containing percentage]>60.0%,[cell containing square footage],0)

putting it in quotes actualy makes it into text, you could do a simple test to see this as so:

=IF(1="1",1,0)

it will always return a 0 as "1" is not the same as the number 1

**Søren Larsen** · 04-11-2012, 02:47 PM

I believe that you should jst remove the "". Unless the percentages are formatted as text...?

You place "" around text, not around a number.

**chop924** · 04-11-2012, 04:17 PM

Yes, found this out about 10 minutes after I posted. Newbie question for sure, but thanks for the help both of you

**DGagnon** · 04-11-2012, 04:18 PM

Any time, no question is a bad question, now that its on the forum, anyone searching on google could stumble across this and help them.

Could you please mark the thread as solved?