I can not use the financial formulas.
 

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 can not use the financial formulas.
 

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))

on an american Pc anyhow....

"Man in Mexico" wrote:

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 can not use the financial formulas.
 

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

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

I can not use the financial formulas.
 

"Ron Rosenfeld" wrote:

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

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