Finding Y when I know X

[Ben_Holmes]

Basic algebra here however struggling to write the formula in Excel so would appreciate your help.

I have the following formula:

y = -0.327ln(x) + 4.0877

How do I plot this in Excel i.e. Finding Y as X Changes!

Apologies probably very simple like me!

Thanks Ben

 

[vds1]

Try,

=(-0.327*LN(A1))+4.0877

where A1 = x

 

[steve the fish]

=-0.327*LN(A1)+4.0877

With A1 being your x value

 

[Ben_Holmes]

Thank you!