I can not use the financial formulas.

[Guest]

I am using Excel v. X for the Mac.
for example I input INT.EFECTIVO(5%;4), I click enter and nothing happen.
I need some help.

 

[Guest]

in English and on PC but this might help

INT returns an integer
Effective returns the effective interest rate
so if you are looking for the integer of the effective interest rate

=INT(Effective(5%,4))

 

[Ron Rosenfeld]

On Mon, 17 Oct 2005 12:11:08 -0700, "Man in Mexico" <Man in

I am using Excel v. X for the Mac.
for example I input INT.EFECTIVO(5%;4), I click enter and nothing happen.
I need some help.

I believe this is the same function as EFFECT in the US version.

What, exactly do you mean when you say "nothing happens"?

If you are getting a #NAME error, you have to install the Analysis Tool Pak.
Instructions for that should be available from HELP for the function.

What, exactly, do you see in the cell where you inputted this formula?
What, exactly, do you see in the function bar?

Did you precede your formula with an "=" sign?

=INT.EFECTIVO(5%;4)

Was the cell formatted as Text when you entered the formula?


--ron

 

[Guest]

On Mon, 17 Oct 2005 12:11:08 -0700, "Man in Mexico" <Man in


I believe this is the same function as EFFECT in the US version.

What, exactly do you mean when you say "nothing happens"?

If you are getting a #NAME error, you have to install the Analysis Tool Pak.
Instructions for that should be available from HELP for the function.

What, exactly, do you see in the cell where you inputted this formula?
What, exactly, do you see in the function bar?

Did you precede your formula with an "=" sign?

=INT.EFECTIVO(5%;4)

Was the cell formatted as Text when you entered the formula?


--ron