some help with getting a formula from an article into excel

[markelz]

hello everyone,

im quite new to this and i thought i would start by jumping into the deep end, so i was trying to get a formula from an article and try to replicate it in excel. but i cant get it to work properly.
so in the article he posts the formula like this: Market value = exp(12.7598) * 56 ^ 4.1167 = $5.5T
where the 56 stands for S2F value wich i have in the G column.

so what i tried so far is: =EXP(12,7598)*G5*LOG(4,1167;10)
=EXP(12,7598)*G5^LOG(4,1167;10)
=EXP(12,7598)*(G5*LOG(4,1167;10))
whatever i do i dont get anywhere close to 5,5T

any help is welcome like i said i just started and am still reading guides, but it is the first time im using the exp and log functions.

greetings mark

 

[KRice]

I don't understand the issue...

Book2
	H
5	5.47364E+12
Sheet2

Cell Formulas
Range	Formula
H5	H5	=EXP(12.7598) * 56 ^ 4.1167

You don't need the LOG function...just raise G5 (56 here) to the power of 4.1167.

 

[markelz]

i tried yours and it gives me #ERROR

 

[markelz]

nevermind. when i copied yours it put 4.1167 and when i changed it to 4,1167 it worked. thanks so much

 

[KRice]

You're welcome. Based on the text in your first post, the exponent appears to be a decimal number between 4 and 5. Do you use a comma as the decimal separator?