Hi Brucas,

An IF formula looks to me the simpliest solution

Column A
0

text

Column B
=IF(A1=0;"RDO";IF(A1="";"RDO";A1))

Copy the formula until the end of the B column.

Does this do the trick?
Tom

On 29 mei, 06:51, brucas wrote:
I am trying to create a formula that will convert cells that are either blank
or displaying a 0 value to displaying "RDO" BUT if I enter a value other than
0 I want it to display that value.
I tried several different things but I am not having any success. Hopefully
someone with much more knowledge than me can help...