If empty command

Hello,

Im trying to write an command for excel where i want it to return a 1 if the selected cell is empty and if its not empty i want it to return a value from another cell. I've tried to create a function, see below. It may make it easier to understand what I'm trying to do, even though its incorrect.

=IF(ISBLANK(A2),1,CL13)

I've also tried

=IF(A2="",1,CL13), but i doesn't work.

So bassically if A2 is blank i want it to return a "1" and if its not blank i want it to return the value in cell CL13.

Can any1 help me fix this?

I think the problem is that Excel doesn't understand that CL13 is a cell...

Thank you!

Saying that " ... it doesn't work ... " is not very helpful. Do you get errors when trying to enter the formula? If so, you may need to use semicolons ( ; ) instead of the commas ( , ) in the formula, like this:

=IF(ISBLANK(A2);1;CL13)

Hope this helps.

Pete

Both of these formulas return the values you seem to be expecting if the formula is placed in any cell.

If you're placing the formula in cell A2, it will cause a circular reference. Might help to clarify where you're putting the formula.

This did the trick, thank you!

Happy to help

(also please mark it as solved in Thread Tools)