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