Finding Y when I know X

Ben_Holmes

Board Regular
Joined
Mar 30, 2004
Messages
147
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
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,110
Office Version
  1. 365
Platform
  1. Windows
=-0.327*LN(A1)+4.0877

With A1 being your x value
 

Watch MrExcel Video

Forum statistics

Threads
1,109,037
Messages
5,526,396
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top