View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
wilywayne wilywayne is offline
external usenet poster
 
Posts: 3
Default Trouble with condition nested formula

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