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(A ND(I21="PI",L21<""),PMT(0.09,30,-L21)))

Can anyone help?

Thanks in advance.

Scott

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(I 21="PI",L21<""),PMT(0.09,30,-L21),""))

"Scoober" wrote:

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(A ND(I21="PI",L21<""),PMT(0.09,30,-L21)))

Can anyone help?

Thanks in advance.

Scott

Try this

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

Mike

"Scoober" wrote:

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(A ND(I21="PI",L21<""),PMT(0.09,30,-L21)))

Can anyone help?

Thanks in advance.

Scott

Thank you sooooooooooo much

"Sheeloo" wrote:

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(I 21="PI",L21<""),PMT(0.09,30,-L21),""))

"Scoober" wrote:

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(A ND(I21="PI",L21<""),PMT(0.09,30,-L21)))

Can anyone help?

Thanks in advance.

Scott

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
---