Help on using multiple IF formula

[questforexcel]

Hi ,

I know how to use the Simple IF and IFS formula.

I am trying to combine two , three IF formulas based on a set criteria but there is an error in my formula.

Could you please help me. Thank you

What I would like my formula to do is search for two conditions in two adjacent cells, if both these conditions are met, then search if there is a beginning value in the adjacent cell, if there is that value, then give me "(D2905+I2906-J2906), if there is not "Beginning Balance", then provide me with alternative of

IF(AND(B2906=B2907,AND(F2907=F2906)),(ISNUMBER(SEARCH("Beginning Balance",C2906)),(D2906+I2907-J2907)),IF(AND(MONTH(F2906)<>MONTH(F2907)),(I2907-J2907),(K2906+I2907-J2907))

 

[questforexcel]

This is exactly what I want to do, But I get the error "#Value"

=IF(AND(B2907<>B2906),H2907+I2907-J2907,IF(ISNUMBER(SEARCH("Beginning Balance",C2906)),(D2906+I2907-J2907),IF(AND(MONTH(F2906)<>MONTH(F2907)),(I2907-J2907),(K2906+I2907-J2907))))

Hi ,

I know how to use the Simple IF and IFS formula.

I am trying to combine two , three IF formulas based on a set criteria but there is an error in my formula.

Could you please help me. Thank you

What I would like my formula to do is search for two conditions in two adjacent cells, if both these conditions are met, then search if there is a beginning value in the adjacent cell, if there is that value, then give me "(D2905+I2906-J2906), if there is not "Beginning Balance", then provide me with alternative of

IF(AND(B2906=B2907,AND(F2907=F2906)),(ISNUMBER(SEARCH("Beginning Balance",C2906)),(D2906+I2907-J2907)),IF(AND(MONTH(F2906)<>MONTH(F2907)),(I2907-J2907),(K2906+I2907-J2907))

 

[gaz_chops]

Maybe

=IF(AND(B2906=B2907,F2907=F2906,ISNUMBER(SEARCH("Beginning Balance",C2906))),D2906+I2907-J2907,IF(AND(MONTH(F2906)<>MONTH(F2907)),I2907-J2907,K2906+I2907-J2907))

 

[questforexcel]

I tried this formula as well, it produces similar results to the previous one.

This formula is exactly what I intend to do. So I want it to search if these rows are not equal, if they are not equal, give me H+I-J, if they are then search for Beg Bal in C and add D + I - J

=IF(AND(B2907<>B2906),H2907+I2907-J2907,IF(ISNUMBER(SEARCH("Beginning Balance",C2906)),(D2906+I2907-J2907),IF(AND(MONTH(F2906)<>MONTH(F2907)),(I2907-J2907),(K2906+I2907-J2907))))

Maybe

=IF(AND(B2906=B2907,F2907=F2906,ISNUMBER(SEARCH("Beginning Balance",C2906))),D2906+I2907-J2907,IF(AND(MONTH(F2906)<>MONTH(F2907)),I2907-J2907,K2906+I2907-J2907))