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??