Multiple IFs in a formula - missing opening or closing parenthesis?

[ianwuk]

Hi Everyone.

I have this formula below:

=IF(B19<=$B4,ROUND(F18+D19+E19,2),IF(B19>$B4,0), IF(ISBLANK(B19),"")

It is supposed to do three conditional things in an Outstanding balance column.

1. If B19 (repayment number) is less than or equal to $B4 (number of months) THEN perform calculation.
2. IF B19 (repayment number) is greater than $B4 (number of months) THEN display zero.
3. IF B19 (repayment number) is blank (due to condition 2), make the cell blank.

Here is how my spreadsheet looks. I have highlighted what I want to be changed to 0, because it exceeds the number of payments:

[/IM

When I run the above formula it says:

The formula is missing an opening or closing paranthesis.

Can anyone kindly help me get this to work please?

I then plan to run conditional formatting to say that if a cell contains 0.00 or N/A respectively then the text is hidden - so basically you only see the calculations for the number of months put in cell B4.

I hope this makes sense.

Thanks.

 

[arthurbr]

Re: Help with multiple IFs in a formula - missing opening or closing parenthesis?

Like this?
=IF(B19="","",if(B19<=$B4,ROUND(F18+D19+E19,2),0)