Formula not showing correct format

**TheLeafs** · 04-19-2011, 08:11 PM

Hey folks,

In my attached file, cell P13 has an IF formula that is returning a value from W12. I want the cell to show in Percent format but when I change it to Percentage the cell stays in number format. Any help would be great.

Thanks,

Chris

**TMS** · 04-19-2011, 08:22 PM

It's a Text value in the cell. Change the formula to:

=--IF(J13="","",IF(J13<=G13,$W$12,"")&IF(T13=4,$X$12,"")&IF(T13=3,$Y$12,"")&IF(T13=2,$Z$12,"")&IF(T13=1,$AA$12,"")& IF(T13=0,$AB$12,"")&IF(U13=4,$AC$12,"")&IF(U13=3,$AD$12,"")&IF(U13=2,$AE$12,"")&IF(U13=1,$AF$12,""))

Note the two minus signs after the equals sign.

Regards

**TheLeafs** · 04-19-2011, 08:25 PM

Works like a champ. Thank you for the quick response.

Chris

**TheLeafs** · 04-19-2011, 08:37 PM

Hey TMShucks,

If I take out the valve in J13 and use the formula you gave me, it ends up with an #VALVE error. Any idea how I can get around that?

Thanks,

**Cutter** · 04-19-2011, 09:12 PM

I'm not sure what you're trying to do with that formula but you are building a text string with it.

Are you attempting something like this?

Please Login or Register  to view this content.

I don't know if I got the references in the right order so you'll have to check out various scenarios.

BTW - this formula yields 2.5% as is but displays 3% because you have it formatted as no decimals. When J13 is blanked P13 also blanks.