Trouble with condition nested formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to nest two formulas based on the result of another cell: the
formula must do one of two functions based result on the lookup cell.

A12: is either "A" or "I"
B1 $100,000
B2 8%
B3 360

formula as written:
=IF( a12="a", (pmt(B2/12,B3,B1)*-1,(B1*B2)/12))
the first argument work fine, howver when I enter the second formula
(b1*b2)/12, it does not work...

CAN ANYONE HELP???
 
=IF( a12="a", -pmt(B2/12,B3,B1),B1*B2/12)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
What happens ?

The example you give doesn't need a ( before PMT
and use "A" in the check not "a"

Steve
 
Back
Top