Excel IF Function
 

Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?

Excel IF Function
 

Hi Kitt,

Anywhere or nowhere - it depends on what, if anything, the IF test is for.
Perhaps you could be more specific?

Cheers


"Kitt" wrote in message
...
Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?

Excel IF Function
 

"macropod" wrote:

Hi Kitt,

Anywhere or nowhere - it depends on what, if anything, the IF test is for.
Perhaps you could be more specific?

Cheers


"Kitt" wrote in message
...
Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?


Sorry, Im very new to this. I am working on a tutorial for a loan calculator. The final total is "Payment per period" and I have been asked for the total to show $0 when the cells are empty instead of error #DIV/0!
The cells are as follows : B3 Annual Interest Rate, B4 Term Of Loan (Years),
B5 Payments per year, B6 Principal, B8 Payment Per Period (Total)
Thanks a million for your prompt reply. Kitt

Excel IF Function
 

maybe you mean? Look in the help index for ISERR
=if(iserr(yourformula),"",yourformula)

--
Don Guillett
SalesAid Software

"Kitt" wrote in message
...
Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?

Excel IF Function
 

Hi Kitt,

In that case, try:
=IF(OR(B5=0,B6=0),0,PMT(B3/B5,B4*B5,B6))
since only B5 and B6 being 0 are likely to cause a #DIV/0! result or, for a
more generalised solution:
=IF(ISERROR(PMT(B3/B5,B4*B5,B6)),0,PMT(B3/B5,B4*B5,B6))

Cheers


"Kitt" wrote in message
...


"macropod" wrote:

Hi Kitt,

Anywhere or nowhere - it depends on what, if anything, the IF test is
for.
Perhaps you could be more specific?

Cheers


"Kitt" wrote in message
...
Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?


Sorry, Im very new to this. I am working on a tutorial for a loan
calculator. The final total is "Payment per period" and I have been asked
for the total to show $0 when the cells are empty instead of error #DIV/0!
The cells are as follows : B3 Annual Interest Rate, B4 Term Of Loan
(Years),
B5 Payments per year, B6 Principal, B8 Payment Per Period (Total)
Thanks a million for your prompt reply. Kitt

Excel IF Function
 

Hi Macropod,
Ok, I was missing the OR function, but it still doesnt' show the total as
$0.00.
I am so grateful for your help, I have been tearing my hair out over this
since last Tuesday!
Kitt

"macropod" wrote:

Hi Kitt,

In that case, try:
=IF(OR(B5=0,B6=0),0,PMT(B3/B5,B4*B5,B6))
since only B5 and B6 being 0 are likely to cause a #DIV/0! result or, for a
more generalised solution:
=IF(ISERROR(PMT(B3/B5,B4*B5,B6)),0,PMT(B3/B5,B4*B5,B6))

Cheers


"Kitt" wrote in message
...


"macropod" wrote:

Hi Kitt,

Anywhere or nowhere - it depends on what, if anything, the IF test is
for.
Perhaps you could be more specific?

Cheers


"Kitt" wrote in message
...
Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?


Sorry, Im very new to this. I am working on a tutorial for a loan
calculator. The final total is "Payment per period" and I have been asked
for the total to show $0 when the cells are empty instead of error #DIV/0!
The cells are as follows : B3 Annual Interest Rate, B4 Term Of Loan
(Years),
B5 Payments per year, B6 Principal, B8 Payment Per Period (Total)
Thanks a million for your prompt reply. Kitt

Excel IF Function
 

I GOT IT!!!
In the Fun Arguments the amount in value_if_true was entered as 0 instead of
$0.00.
Thank you, thank you, thank you for all your help.
Cheers!
Kitt

"Kitt" wrote:

Hi Macropod,
Ok, I was missing the OR function, but it still doesnt' show the total as
$0.00.
I am so grateful for your help, I have been tearing my hair out over this
since last Tuesday!
Kitt

"macropod" wrote:

Hi Kitt,

In that case, try:
=IF(OR(B5=0,B6=0),0,PMT(B3/B5,B4*B5,B6))
since only B5 and B6 being 0 are likely to cause a #DIV/0! result or, for a
more generalised solution:
=IF(ISERROR(PMT(B3/B5,B4*B5,B6)),0,PMT(B3/B5,B4*B5,B6))

Cheers


"Kitt" wrote in message
...


"macropod" wrote:

Hi Kitt,

Anywhere or nowhere - it depends on what, if anything, the IF test is
for.
Perhaps you could be more specific?

Cheers


"Kitt" wrote in message
...
Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?


Sorry, Im very new to this. I am working on a tutorial for a loan
calculator. The final total is "Payment per period" and I have been asked
for the total to show $0 when the cells are empty instead of error #DIV/0!
The cells are as follows : B3 Annual Interest Rate, B4 Term Of Loan
(Years),
B5 Payments per year, B6 Principal, B8 Payment Per Period (Total)
Thanks a million for your prompt reply. Kitt

Excel IF Function
 

Isn't this sufficient?

=IF(B5,PMT(B3/B5,B4*B5,B6),0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537573

Excel IF Function
 

Hi daddylonglegs,

Not if B4 is zero. The correct rendition should have been:
=IF(OR(B5=0,B4=0),0,PMT(B3/B5,B4*B5,B6))

An alternative rendition would be:
=IF(B5*B4=0,0,PMT(B3/B5,B4*B5,B6))

Cheers

"daddylonglegs"
wrote in message
news:daddylonglegs.2735jy_1146414602.3281@excelfor um-nospam.com...

Isn't this sufficient?

=IF(B5,PMT(B3/B5,B4*B5,B6),0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537573

Excel IF Function
 

macropod Wrote:
Hi daddylonglegs,

Not if B4 is zero. The correct rendition should have been:
=IF(OR(B5=0,B4=0),0,PMT(B3/B5,B4*B5,B6))

An alternative rendition would be:
=IF(B5*B4=0,0,PMT(B3/B5,B4*B5,B6))

Cheers



Indeed macropod, you are correct, although, based on my original
formula, you can use

=IF(B5*B4,PMT(B3/B5,B4*B5,B6),0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537573