Thanks Guys,
Your suggestions have actually helped me out a lot to understand what it is
that I am trying to do. What I had earlier is exactly the formula you have
below David.
As I was saying before though, I think that I will just have to leave it
showing the RDO on the worksheet as the default value instead of having white
spaces because if I use conditional formatting to make the RDO "invisible"
they will not show when I enter the rest of the data, hence I'm back where I
started this morning - Oh well, tomorrow is another day and the plight of a
perfectionist is never ending dissatisfaction...
--
Stupid questions from a beginner...


"David Biddulph" wrote:

And (apologies for following up my own post) as an empty cell is treated as
zero,
=IF(C3=0,"RDO",C3) will do.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Your amended formula will give RDO for a blank cell or for a text string
of "0", but not for a number of zero. The quote marks denote a text
string.

Also, you don't need 2 IFs. An OR will do.
=IF(OR(C3=0,C3=""),"RDO",C3)
--
David Biddulph

"brucas" wrote in message
...
...
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.
...
"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...