software

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

Hi Kitt,

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

Cheersquot;Kittquot; gt; wrote in message
...
gt; Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?


quot;macropodquot; wrote:

gt; Hi Kitt,
gt;
gt; Anywhere or nowhere - it depends on what, if anything, the IF test is for.
gt; Perhaps you could be more specific?
gt;
gt; Cheers
gt;
gt;
gt; quot;Kittquot; gt; wrote in message
gt; ...
gt; gt; Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?
gt;
gt;
gt; Sorry, Im very new to this. I am working on a tutorial for a loan calculator. The final total is quot;Payment per periodquot; 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

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

--
Don Guillett
SalesAid Software

quot;Kittquot; gt; wrote in message
...
gt; Where in =PMT(B3/B5,B4*B5,B6) do you enter the 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))

Cheersquot;Kittquot; gt; wrote in message
...
gt;
gt;
gt; quot;macropodquot; wrote:
gt;
gt; gt; Hi Kitt,
gt; gt;
gt; gt; Anywhere or nowhere - it depends on what, if anything, the IF test is
for.
gt; gt; Perhaps you could be more specific?
gt; gt;
gt; gt; Cheers
gt; gt;
gt; gt;
gt; gt; quot;Kittquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?
gt; gt;
gt; gt;
gt; gt; Sorry, Im very new to this. I am working on a tutorial for a loan
calculator. The final total is quot;Payment per periodquot; and I have been asked
for the total to show $0 when the cells are empty instead of error #DIV/0!
gt; The cells are as follows : B3 Annual Interest Rate, B4 Term Of Loan
(Years),
gt; B5 Payments per year, B6 Principal, B8 Payment Per Period (Total)
gt; Thanks a million for your prompt reply. Kitt
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

quot;macropodquot; wrote:

gt; Hi Kitt,
gt;
gt; In that case, try:
gt; =IF(OR(B5=0,B6=0),0,PMT(B3/B5,B4*B5,B6))
gt; since only B5 and B6 being 0 are likely to cause a #DIV/0! result or, for a
gt; more generalised solution:
gt; =IF(ISERROR(PMT(B3/B5,B4*B5,B6)),0,PMT(B3/B5,B4*B5,B6))
gt;
gt; Cheers
gt;
gt;
gt; quot;Kittquot; gt; wrote in message
gt; ...
gt; gt;
gt; gt;
gt; gt; quot;macropodquot; wrote:
gt; gt;
gt; gt; gt; Hi Kitt,
gt; gt; gt;
gt; gt; gt; Anywhere or nowhere - it depends on what, if anything, the IF test is
gt; for.
gt; gt; gt; Perhaps you could be more specific?
gt; gt; gt;
gt; gt; gt; Cheers
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Kittquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Sorry, Im very new to this. I am working on a tutorial for a loan
gt; calculator. The final total is quot;Payment per periodquot; and I have been asked
gt; for the total to show $0 when the cells are empty instead of error #DIV/0!
gt; gt; The cells are as follows : B3 Annual Interest Rate, B4 Term Of Loan
gt; (Years),
gt; gt; B5 Payments per year, B6 Principal, B8 Payment Per Period (Total)
gt; gt; Thanks a million for your prompt reply. Kitt
gt;
gt;
gt;

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

quot;Kittquot; wrote:

gt; Hi Macropod,
gt; Ok, I was missing the OR function, but it still doesnt' show the total as
gt; $0.00.
gt; I am so grateful for your help, I have been tearing my hair out over this
gt; since last Tuesday!
gt; Kitt
gt;
gt; quot;macropodquot; wrote:
gt;
gt; gt; Hi Kitt,
gt; gt;
gt; gt; In that case, try:
gt; gt; =IF(OR(B5=0,B6=0),0,PMT(B3/B5,B4*B5,B6))
gt; gt; since only B5 and B6 being 0 are likely to cause a #DIV/0! result or, for a
gt; gt; more generalised solution:
gt; gt; =IF(ISERROR(PMT(B3/B5,B4*B5,B6)),0,PMT(B3/B5,B4*B5,B6))
gt; gt;
gt; gt; Cheers
gt; gt;
gt; gt;
gt; gt; quot;Kittquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;macropodquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi Kitt,
gt; gt; gt; gt;
gt; gt; gt; gt; Anywhere or nowhere - it depends on what, if anything, the IF test is
gt; gt; for.
gt; gt; gt; gt; Perhaps you could be more specific?
gt; gt; gt; gt;
gt; gt; gt; gt; Cheers
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Kittquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; Sorry, Im very new to this. I am working on a tutorial for a loan
gt; gt; calculator. The final total is quot;Payment per periodquot; and I have been asked
gt; gt; for the total to show $0 when the cells are empty instead of error #DIV/0!
gt; gt; gt; The cells are as follows : B3 Annual Interest Rate, B4 Term Of Loan
gt; gt; (Years),
gt; gt; gt; B5 Payments per year, B6 Principal, B8 Payment Per Period (Total)
gt; gt; gt; Thanks a million for your prompt reply. Kitt
gt; gt;
gt; gt;
gt; gt;


Isn't this sufficient?

=IF(B5,PMT(B3/B5,B4*B5,B6),0)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=537573Hi 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

quot;daddylonglegsquot; gt;
wrote in message
news:daddylonglegs.2735jy_1146414602.3281@excelfor um-nospam.com...
gt;
gt; Isn't this sufficient?
gt;
gt; =IF(B5,PMT(B3/B5,B4*B5,B6),0)
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile:
www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=537573
gt;

macropod Wrote:
gt; Hi daddylonglegs,
gt;
gt; Not if B4 is zero. The correct rendition should have been:
gt; =IF(OR(B5=0,B4=0),0,PMT(B3/B5,B4*B5,B6))
gt;
gt; An alternative rendition would be:
gt; =IF(B5*B4=0,0,PMT(B3/B5,B4*B5,B6))
gt;
gt; Cheers
gt;
gt;

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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=537573