Displaying text based on a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
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?
 
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
Click to expand...
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
 
Back
Top