looking at a blacnk cell and need to do and if statement

[mkrieger]

Please help. I am trying to create a formula that looks at a cell. I
that cell is black I need to have another cell used in a calcualtion
if that cell has a figure I need that cell used in the calculation.
Can anyone help me please.

Or, can anyone answer why if I do an isblank formula, I can get it t
show me that this is true, but if I put in a number and then remove th
number I can not get it to tell me this statement is true again.

Thanks. She

 

[Frank Kabel]

Hi
try something like
=IF(A1="",B1*2,A1*2)

or
=IF(ISBLANK(A1),B1*2,A1*2)

When you remove the value how do you do it? Do you press the DEL key
(or are you inserting a space?)

 

[mkrieger]

Thanks I'll give those a try. One problem I was having was that th
cell I was looking to see if it was blank had a calculated figure i
it. Does this really matter