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)

"wilywayne" wrote in message
...
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???

What happens ?

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

Steve
On Thu, 31 Aug 2006 17:16:02 +0100, wilywayne
wrote:

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