#### questforexcel

##### Board Regular

- Joined
- Jan 18, 2019

- Messages
- 95

I am trying to use a Multiple IF formula to help me give the values if the following conditions are met, but it gives me a #Value error.

Could you please help me figure out the correct formula for this.

Thank you

=IF(AND(B2034<>B2035),H2035+I2035-J2035,IF(ISNUMBER(SEARCH("Beginning Balance",C2035)),(D2035+I2035-J2035),IF(AND(MONTH(F2035)<>MONTH(F2034)),(I2035-J2035),(K2034+I2035-J2035))))