#Num! error

[wannabepro]

Hi,

I have done my search and what I found was not sufficient enough for one of my query. It was for most of the fields but not for all.

=Pmt((1+[Annual Interest Rate]/2)^(1/6)-1,[Amortization]*12,-((([Annual Rent]+[num8]+[num9]+[num0]-[Perc1]*[Annual Rent])-([Taxes]+[Insurance]+[Utilities]+([num11]-([Taxes]+[Insurance]+[Utilities]+[Management Allowence]))+[On site Management]+[Structural allowance]+[Management Allowence])-[Ground Lease])/[Perc4])*[Perc6],0)*12

I know its huge calculation, but for some reason I am getting #num! error in its field. I know that I am suppose to use Iff([Field1],0 ([Field]/[Field1]), 0) statement. But, this is not working for this calculation. While, it did work for others.

I would really appreciate your help, thanx in adv.

 

[KenHigg]

wannabe,

I would send all this out to a function...

 

[wannabepro]

wannabe,

I would send all this out to a function...

if you don't mind, can you tell me how would you do that. I haven't dealt with functions, so not so good at that.

 

[KenHigg]

Hum...

To start with, can you break it down so that it's more readable?

 

[wannabepro]

Hum...

To start with, can you break it down so that it's more readable?

how do you want me to do that sorry I guess I am just too confused after a long day

 

[KenHigg]

Wanna - I need to bug out in few minutes - Maybe someone else can pick up or maybe offer another solution....

 

[wannabepro]

Wanna - I need to bug out in few minutes - Maybe someone else can pick up or maybe offer another solution....

okay, thanx for your help though

 

[boblarson]

For starters, I don't know if this is a typo here or in your actual code, but you wrote:

Iff([Field1],0 ([Field]/[Field1]), 0)

and it should be:

Iff([Field1][B]=0[/B], 0,([Field]/[Field1]))

Also, make sure that your text boxes are not named the same as your fields (which is the default way Microsoft sets up a form if you use the Wizard). If named the same, it can cause you to get errors like this too.

 

[wannabepro]

For starters, I don't know if this is a typo here or in your actual code, but you wrote:

Iff([Field1],0 ([Field]/[Field1]), 0)

and it should be:

Iff([Field1][B]=0[/B], 0,([Field]/[Field1]))

Also, make sure that your text boxes are not named the same as your fields (which is the default way Microsoft sets up a form if you use the Wizard). If named the same, it can cause you to get errors like this too.

that was a typo, I did everything I can, still its there. Well, I am sure, I will solve it eventually. thanx though