# MS Excel geeks, can you help?

Hope i explain this okay.

I have a formula that's creating a percentage, so one figure divided by another, with the cell formatted as %.

The formula is also an If statement and I want it to say 'if the % is below a certain number then show the % with a * after it, e.g. 45%*.

The formula is fine, but I can't figure out how to put the * on then end.

I tried concatenating, so 'cell&"*"' , but that then doesn't display the result as a %, just as a decimal, so instead of 45%, it gives me 0.4512345*.

Any ideas anyone??

I have a formula that's creating a percentage, so one figure divided by another, with the cell formatted as %.

The formula is also an If statement and I want it to say 'if the % is below a certain number then show the % with a * after it, e.g. 45%*.

The formula is fine, but I can't figure out how to put the * on then end.

I tried concatenating, so 'cell&"*"' , but that then doesn't display the result as a %, just as a decimal, so instead of 45%, it gives me 0.4512345*.

Any ideas anyone??

If your calculation was (for example) the result of 1 divided by 2, then this formula may be used:

=IF(1/2<0.6,TEXT(1/2,"0%\*"),"Other answer")

If the result of the formula is less than 0.6 (i.e. 60%), then the result is shown as a percentage (with a trailing % symbol and asterisk character).

Otherwise, the "Other answer" text represents what you wish to display if the result is not less than 60%.

Original Poster

That would format the cell no matter what, I just want the * there as the result of the if statement, so it wouldn't always be there

Original Poster

What is the \ after the % ?

Doesn't seem to work.

Original Poster

Original Poster

GOing home but will try this tomorrow!

It does work!

The \ before any character uses the exact (explicit) character in an "escaped" form.

Look at it again tomorrow when you have more time.

Original Poster

Bigfoot wins! Thanks so much!

=IF(cell<0.65,ROUND(cell*100,0)&"%*",ROUND(cell*100,0)&"%")

Replace cell and 0.65 with your values

This is for display purposes only. It will not allow further calculations on result.

Happy trails

Original Poster

Interesting, not seen the use of the \ like that will give it a try too. Thanks

Original Poster

I did thank everyone earlier