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

[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

 

[Peo Sjoblom]

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

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.

 

[may]

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

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.