Perform If function if the cell is blank

I have a range of cells that for some there is already some information cotained in them, but for the other cells in the range they are blank.

I tried using some like the following:
=IF(W45>0,Y45/(1-0.33))

which is supposed to be if cell w45 is greater than 0 leave it alone, but if cell W45 had been blank then perform the calculation on the number that is in cell Y45. I am sure I am doing this wrong, but some suggestions would be helpful.

Hi

You mean something like this?

=IF(W45>0;(Y45/(1-0,33));"")

Hope to helps you.

Are you entering the formula into W45 by any chance? If so, it won't work. You cannot have both a formula and a value in a cell and entering the formula will wipe out the pre-existing value. What you could perhaps do is use the Goto - Special... Blanks option to select the currently empty cells and enter the formula into them only.

Corect. Formula must be in another cell! That is what i understand that capnhud's want to do.

@OnErrorGoto0 no it is not going in the same cell

@Fotis1991

Maybe I am doing something wrong with the formula but it is errorring, here is an example sheet to show what I am trying to do. Ideally I would like the empty cell in A to be filled with the calculation from B if it evaluates to false

Your row references are wrong. See attached version.

..Formula give you a blank cell(in B1), because A2 is blank.!

Your formula is:=IF(A2>0;(C3/(1-0,33));"")

If you do the formula, like this, it's OK.

=IF(A1>0;(C3/(1-0,33));"")

Ok see that was part of my problem, but is it not possible to have the if function perform the calculation is the cell is blank, and skip those that have a value.

the attached file has explanations indicating what I am trying to say.

Not following you I am afraid. If you want the formula in column A, just enter it there.

The result of the formula calculation, in B2, is FALSE.

Is this what you want?

Hopefully this a better picture of what I am trying to do

A	B	C
15	since a value in A1 formula does not affect A1	5
value enter here	since A2 is blank	15
value enter here	since A3 is blank	15
15	since a value in A4 formula does not affect A4	5
value enter here	since A5 is blank	15

Is this what you mean?
In B2

Please Login or Register  to view this content.

Can you give specific example re
What goes in A2, and what in B2 and why to both?

If you need the result in one column, you can't do it with Column A
However you can with Column B

Please Login or Register  to view this content.

I'd be surprised if the OP is not confused by now....

Why does B2 check A1?

Perhaps forget about the actual formula for now and merely explain the logic flow to us?

(if by chance this is relevant, you cannot populate column A from a formula in column B)

Originally Posted by OnErrorGoto0

Why does B2 check A1?

Perhaps forget about the actual formula for now and merely explain the logic flow to us?

(if by chance this is relevant, you cannot populate column A from a formula in column B)

That is what I realizing

Originally Posted by NBVC

I'd be surprised if the OP is not confused by now....

Naw I keeping up

@ Marcol that does exactly what I wanted and I guess the answer to the question is no the result of the calculation value cannot be entered in column A


I wanna thank all of you for your input and assistance in helping to solve this problem