What am I missing?

[Scoober]

Hi,

This formula does everything correct until L21 is left blank and then I get
a 'FALSE' value in O21 instead of an empty cell.


O21:=IF(AND(I21="IO",L21<>"",N21<>""),L21*N21,IF(AND(I21="PI",L21<>""),PMT(0.09,30,-L21)))

Can anyone help?

Thanks in advance.

Scott

 

[Sheeloo]

You have not specified the ELSE path for the second condition. Add "" before
the )) at the end.
Use thi
=IF(AND(I21="IO",L21<>"",N21<>""),L21*N21,IF(AND(I21="PI",L21<>""),PMT(0.09,30,-L21),""))

 

[Mike H]

Try this

=IF(AND(I21="IO",L21<>"",N21<>""),L21*N21,IF(AND(I21="PI",L21<>""),PMT(0.09,30,-L21),""))

Mike

 

[Scoober]

Thank you sooooooooooo much

You have not specified the ELSE path for the second condition. Add "" before
the )) at the end.
Use this
=IF(AND(I21="IO",L21<>"",N21<>""),L21*N21,IF(AND(I21="PI",L21<>""),PMT(0.09,30,-L21),""))

 

[Max]

Please note that I had given you the correct expression* to use earlier which
would not have resulted in FALSE.
*other than the revision to your subsequent follow-on on the "PMT" part
which was answered by Fred
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---