Display numerical result of a cell with Text as well

I want to display in cell A2 the numerical result of cell A1.

If the result is <=.99, I also want it to put a 'p' after the amount and the words "Special".

If the result is >.99, I want it to put a £ sign in front of the value, but no p after it, and also the word "Special".

Try this:

=IF(A1<=0.99,A1&"p Special",CHAR(163)&A1&" Special")

- Moo

Brilliant, thank you so much!!

You're welcome. Glad I could help!

- Moo

- - - - - - - - - -
If you are satisfied with the solution(s) provided, please mark the thread as [SOLVED] by clicking on the words 'Thread Tools' above your 1st post in this thread. Then select 'Mark Thread as Solved'.

Also, a good way to 'Say thanks' to those who have helped is to click on the star below their name in one of their posts. It's always appreciated.