Unfortunately not... It won't allow me to process it as it contains an error.
I have been trying to use various IF formulas to no avail.
The best I could get it to do default all the highlighted cells to RDO when
I copied them down. When I then enter other data it erases the formula ,hence
the RDO, but if I hit enter RDO remains (which is what I ultimately want to
happen). I may have to leave it that way however it makes the worksheet look
very busy and I prefer to be looking at a clean page.

HOLD ON... I altered the formula you gave me one last time and it has worked.

=IF(C3="0","RDO",IF(C3="","RDO",C3))

When I put the 0 into the "" it worked.

Thanks Heaps!! BUT now I have another one...

Does the IF Formula have to be in a seperate column? or can it be set to
"run in the background" on the column you are entering data?
I'll have a play and see as I'm determined to get this to work.

--
Stupid questions from a beginner...


"fake_be" wrote:

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...