Help with an If statement

[Quicksilver16]

I have an if statement =IF(B7>=35%,"Y",0) that is looking at cell B7 which is a formula =SUM('03Roof'!H29), but it isn't responding correctly to the result that B7 is coming back with. When it returns 35% or greater it still says 0, but if I manually enter a 35% in B7, then it returns the correctly result.

How do I fix this?

Thanks!

[hoyasaxa215]

Try changing it as follows and see if it works:

Please Login or Register  to view this content.

[mehmetcik]

35% returned by a formula is 0.35, the cell formatting makes it look like 35%

Your formula should be:-

Please Login or Register  to view this content.

[Paul]

Why are you using SUM(one_cell)? Just use ='03Roof'!H29

What is the value in cell H29? (Not what is shown on screen, but the actual value of the cell.) If the value is 35, then there's your problem.

In Excel, 35% is 0.35, while 35 would equate to 3500%. (Multiply decimal by 100.)

Although, 35 is still greater than or equal to 0.35, so it should show "Y". Are H29 or B7 formatted as text?

[Quicksilver16]

I changed it to =IF(B7>=0.35,"Y",0) and it still returned 0.

Paul - I used =SUM before "03Roof'!H29 because I just click on formulas the the sum symbol and go to the tab where the number is that I need and click on it. It's just easier than typing in the name of the tab. When I click on H29 the formula that is in there is =F29/G29. It returned 35% in the cell and that's what I see, but there is a formula attached to it. Thanks.

[Paul]

Try posting the workbook (Reply - Go Advanced - Manage Attachments). Remove any sensitive data first (and any unnecessary sheets).

[Quicksilver16]

I just figured out that it's not picking up the > or = part of my formula because when B7 is 36%, it works. It's not picking up the = to part of the formula.