Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel IF Function
Where in =PMT(B3/B5,B4*B5,B6) do you enter the IF Function?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |