multiple formats in a cell

[Gridlock]

I'm trying to find a way of displaying the content of a cell as either a
number or a percentage depending on the output from a lookup. I'm struggling
to find a way to do this in Excel 2003. Can you help please?

 

[Ms-Exl-Learner]

Provide some examples about your data and how would you like to get the result…

 

[Don Guillett]

???
=IF(D4<1,TEXT(D4,"0.00%"),TEXT(D4,"#"))