Percentages formula

[daxcrocker]

Could someone please tell me what is the formula for the following for cells C12/B12: If the answer is less than 1 percent I want it to show <1%, and if the answer is more than 1%, I want it to show the actual percentage.

Thank you.

Dax

[alansidman]

=if(C12/B12<.01,"<1%",C12/B12). Format your cell as percentage

[daxcrocker]

Thank you Alan. The only problem I am having with it is that if on column C12 I have a 0, it shows <1% instead of 0. Any ideas?

Dax

[alansidman]

=if(c12=0,0,if(C12/B12<.01,"<1%",C12/B12))

[daxcrocker]

If the answer is O, I want it to show 0, if the answer is less than 1%, I want it to show <1, other than that the actual number. Ex, if C12/B12 = 0, show 0, if C12/B12 = .01, show <1, if C12/B12 = 234, show 234

[alansidman]

Did you try my formula from post 4.

[daxcrocker]

They are changing so quickly I don't know what is post 4, what is the title?

[daxcrocker]

I got it, let me try it. Sorry.

[alansidman]

It is the 4th post in this thread numbered over in the right hand side as you scroll down. This is post 9. Your last one was post 8.

[daxcrocker]

Thank you so much, it worked.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks. And you are welcome