How to maintain the cell formatt....

[albertc30]

Morning all.

Hope everybody is holding well and safe.

Once again, here I am with yet another question. The answer is probably easy too but for the life of me, I just can't seem to work it out.

I have the following formula on a cell;

=IF(Y21/R21>=0.1,Y21/R21&" Target Achieved"&Horn(),Y21/R21)

The cell is formatted to show percentage number. Now it works till value if true is triggered. Then the value becomes whole number with 15 decimal places. Is there a way to give this a formatt included on the formula?

Many thanks and be safe everyone.

Thanks.
Albert

 

[albertc30]

I am as far as trying to implement the TEXT function...

I think I am in the right track here?

 

[gaz_chops]

Try

=IF(Y21/R21>=0.1,TEXT(Y21/R21,"#.#%")&" Target Achieved"&Horn(),TEXT(Y21/R21,"#.#%"))

 

[albertc30]

Try

=IF(Y21/R21>=0.1,TEXT(Y21/R21,"#.#%")&" Target Achieved"&Horn(),TEXT(Y21/R21,"#.#%"))

Cool man.

It works.

I am happy I was in the right direction but didn't quit get there before you did.

Many thanks mate. Much appreciated.

Be safe all.

 

[gaz_chops]

You're welcome, you where on the right lines.

Gaz