IF AND Statements

[TommyDoes]

=C13+IF(AND(Input!B17<(Input!B5*(Input!B6/12*(MonthsOpen-1)))),C11>C13,C11-C13,0)

This is my first time using excel's IF AND statements. Can anyone tell me what is wrong with this formula without looking at the actual data?

Thank you

 

[Jonmo1]

Welcome to the board.

Looks like 1 misplaced )

=C13+IF(AND(Input!B17<(Input!B5*(Input!B6/12*(MonthsOpen-1)))),C11>C13,C11-C13,0)

Try
=C13+IF(AND(Input!B17<(Input!B5*(Input!B6/12*(MonthsOpen-1))),C11>C13),C11-C13,0)

But that is just a guess..

Otherwise we'd need at least a worded explaination of what the formula is supposed to do.

 

[TommyDoes]

Thank you Jonmo. I think that solved the problem.

 

[Jonmo1]

You're welcome