exponetial's in Excell 97

  • Thread starter Thread starter gbuter
  • Start date Start date
G

gbuter

exponetial(5.228-1.154*LN(VAR1))-0.2038LN(var2)-(0.299 if Female)+(0.19
if African-American)
LN=natural log
How do I use this formula in Excell 9
 
=EXP(5.228-1.154*LN(VAR1))-0.2038*LN(var2)+IF(Gender="Female",-0.299,0)+IF(E
thnicity="African-American",0.192,0)

where VAR1, var2, Gender and Ethnicity are named cells carrying the related
parameters.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error '6' Overflow 10
Weibull function in Excel 3
Make all variable values in a Array equal to 0 8
Matrix to a Column Report 8
INDIRECT Link of Variables for VLOOKUPs 6
execute a function with a dynamic name 1
Help with Value in one column... 3
Array of Classes with user-defined constructor with parameters 2

Back
Top