Logarithmic Trends - Excel Formula

[sabrina0034]

Hello All,

Wondering if anyone knows how to set up a formula that will calculate the answer to these equations which Excel generated for 3 points (represents 3 years... I need to forecast the 4th period, therefore x=4.

I want to enter the formula that would calculate these two functions, directly into the cell:
<TABLE style="WIDTH: 125pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=167 border=0><COLGROUP><COL style="WIDTH: 125pt; mso-width-source: userset; mso-width-alt: 6107" width=167><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 125pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=167 height=20>y = 7E+09ln(x) + 5E+10
y = 1E+09ln(x) + 7E+09
</TD></TR></TBODY></TABLE>

Anyone know how?

Thanks in advance!

 

[GlennUK]

If you type:
= 7e+9*LN(4) + 5e+10
into a cell, does it give the answer you want?