IF statment with """ markings

[bobo17]

Hi
I am just getting into understanding formulas etc. I have a Dividend Reinvestment spreadsheet (tracks dividend paying stocks performance etc.) and there are some complicated formulas embedded in it. I am trying to understand them.
Here is one that I need help with, specifically what the character "" would mean in relation to this formula?:

=IF(FALSE,0,IF(AND(OR(B22="",C22=""),D22=""),"",IF(P22<>"",P22,B22*C22)+D22))


thanks in advance any suggestions are appreciated
bobo

 

[ivanribic]

hi.
Can someone be so kind as to state what the formula is saying in english, so I can follow the equation? I think i am mostly there but not sure what the comma between P22, B22 is saying? Rather than bouncing questions back and forth, maybe an english interpretation will suffice.

=IF(FALSE,0,IF(AND(OR(B22="",C22=""),D22=""),"",IF(P22<>"",P22,B22*C22)+D22))

The comma between the P22 and B22 separates the TRUE and FALSE functions of that "IF" statement.

Basically, this is what the formula says:

IF(Cell Value is FALSE, then then return a 0, IF(cell value is NOT FALSE then check to see if cell B22 OR C22 are blank AND also check if D22 is blank), if both D22 AND either B22 or C22 are blank, then return a BLANK value to this cell (""), if any part of the previous statement is NOT true then check IF(P22 is not blank, if it's TRUE that P22 is not blank then display the value of P22+D22, otherwise if P22 IS blank then multiply the value of B22 and C22 and add the product to the value of D22 ((B22*C22)+D22).

 

[Scott Huish]

That is not quite correct:


IF(Cell Value is FALSE,

There is no reference to a cell, it says if FALSE, the TRUE condition would never be executed.

For example:

=IF(FALSE,1,2)

The Condition part evalutes to FALSE, so it will always execute the FALSE condition.

 

[Marcelo Branco]

That is not quite correct:


IF(Cell Value is FALSE,

There is no reference to a cell, it says if FALSE, the TRUE condition would never be executed.

For example:

=IF(FALSE,1,2)

The Condition part evalutes to FALSE, so it will always execute the FALSE condition.

So, if i understand correctly, this part is useless and the formula can be shortened to

=IF(AND(OR(B22="",C22=""),D22=""),"",IF(P22<>"",P22,B22*C22)+D22))

Am i right?

M.

 

[T. Valko]

So, if i understand correctly, this part is useless and the formula can be shortened to

=IF(AND(OR(B22="",C22=""),D22=""),"",IF(P22<>"",P22,B22*C22)+D22))

Am i right?

M.

You are correct.

On a side note...

That's a really unusual formula. The first part is not needed:

=IF(FALSE,0

=IF(AND(OR(B22="",C22=""),D22=""),"",IF(P22<>"",P22,B22*C22)+D22)

 

[Marcelo Branco]

You are correct.

Tks T.

M.

 

[bobo17]

Thanks again.
Its hard for a newbie to decipher these embedded conditions, but with your help and reviewing, i am sure it will become clearer.

again, this is a spreadsheet that someone made to track stock & dividend performance, so I guess the formulas used could be truncated, but it could be that the original make of the the spreadsheet used the formula construction that he was familiar with.

bobo

bobo

 

[T. Valko]

Tks T.

M.

You're welcome!