Conditional format

B

Bee

Hi, how do I display a cell as follows:

If it's <50, show it as a %
If it's >50 show it as a decimal

It needs formating in the actual cell that the manager would enter a figure
into.

Thanks
 
B

Bob Phillips

Try a custom format of

[<.5]0%;General

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top