I can not use the financial formulas.

M

Man in Mexico

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.
 
V

Vacation's Over

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

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.
Click to expand...

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
 
M

Man in Mexico

Ron Rosenfeld said:
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
Click to expand...
 
Top