£0.00 @

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 sa… Read More

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

Tags:

Options

## All Responses

(15) Jump to unreadPost an answerI 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%.

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(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%.

Doesn't seem to work.

=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%.

Doesn't seem to work.

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.

=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

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

Doesn't seem to work.

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

Look at it again tomorrow when you have more time.