Displaying text based on a formula

[Guest]

This may not be a big problem, but I am trying to make a cell display text if there is a value in another cell. I think the problem may be that the cell I am pointing to has a formula in it. I have locked the cell do I have to hide it as well?

Here are the formulas I have:
(in the first cell (D18)): =IF(E12>0,"1",IF(E13>0,"2",IF(E14>0,"2.567",IF(E15>0,"",""))))
(in the second cell (D19)): =IF(D18>0,"A","")

D19 should be blank until a value is entered in D18. Is this possible?

Please help...

Thanks.

K.Swick

 

[May]

I think you need to take out the quotes in your formula on
D18. Like this:
=IF(E12>0,1,IF(E13>0,2,IF(E14>0,2.567,IF(E15>0,,))))

-----Original Message-----
This may not be a big problem, but I am trying to make a

cell display text if there is a value in another cell. I
think the problem may be that the cell I am pointing to
has a formula in it. I have locked the cell do I have to
hide it as well?

 

[Guest]

May - If I take out the quotes won't excel treat the values as numbers? If so, I have some that are 0.412..

----- May wrote: ----

I think you need to take out the quotes in your formula on
D18. Like this
=IF(E12>0,1,IF(E13>0,2,IF(E14>0,2.567,IF(E15>0,,)))

-----Original Message----
This may not be a big problem, but I am trying to make a

cell display text if there is a value in another cell. I
think the problem may be that the cell I am pointing to
has a formula in it. I have locked the cell do I have to
hide it as well