Checking a cell to see if it ISBLANK?? HELP PLEASE!!!

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

Guest

I am trying to make cell D19 look at cell D18 to see if it is blank. Cell D18 contains a formula. The formula is as follows:

=IF($M$5>0,IF(E$12>0,"300",IF(E$13>0,"1.667",IF(E$14>0,"166.667",IF(E$15>0,"","")))))

This formula works fine, I just need to figure out how to make cell D19 not see the formula but see if one of the values has been entered in the cell. Would it help if I took off the last set of quotes? I want to make the formula in D19 place an "A" in the cell if there is a value in D18. If you need more information, let me know.

Thank you for your time and help! I really appreciate it!

Kelly
 
First of all, remove the quotes around the numbers, or else they will be
text,
I am not sure what it is supposed to be but you might want to try with

=IF(OR($M$5>0,E$12>0),300,IF(E$13>0,1.667,IF(E$14>0,166.667,IF(E$15>0,"","")
)))



--

Regards,

Peo Sjoblom


Kelly said:
I am trying to make cell D19 look at cell D18 to see if it is blank. Cell
Click to expand...
D18 contains a formula. The formula is as follows:
=IF($M$5>0,IF(E$12>0,"300",IF(E$13>0,"1.667",IF(E$14>0,"166.667",IF(E$15>0,"
","")))))

This formula works fine, I just need to figure out how to make cell D19
Click to expand...
not see the formula but see if one of the values has been entered in the
cell. Would it help if I took off the last set of quotes? I want to make
the formula in D19 place an "A" in the cell if there is a value in D18. If
you need more information, let me know.
 
I think you need to take the quotes out in your D18
formula. Like this:
=IF(E12>0,1,IF(E13>0,2,IF(E14>0,2.567,IF(E15>0, , ))))
-----Original Message-----
I am trying to make cell D19 look at cell D18 to see if
Click to expand...
it is blank. Cell D18 contains a formula. The formula is
as follows:
=IF($M$5>0,IF(E$12>0,"300",IF(E$13>0,"1.667",IF (E$14>0,"166.667",IF(E$15>0,"","")))))

This formula works fine, I just need to figure out how to
Click to expand...
make cell D19 not see the formula but see if one of the
values has been entered in the cell. Would it help if I
took off the last set of quotes? I want to make the
formula in D19 place an "A" in the cell if there is a
value in D18. If you need more information, let me know.
 
Back
Top