Question description:
This user has given permission to use the problem statement for this
blog.
I need help with solving equations using separate columns. For example. One column has pH values going from 0-14 and the column next to it has the equation [H+] = 10^-pH with it's corresponding values.
Solved by I. J. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
26/02/2018 - 07:49
Welcome to excel got it pro.
Excelchat Expert
26/02/2018 - 07:49
Please tell me details with example showed on the preview sheet.
User
26/02/2018 - 07:51
give me a secong
User
26/02/2018 - 07:51
second
User
26/02/2018 - 07:51
im not too savy with excel
Excelchat Expert
26/02/2018 - 07:51
sure, take your time.
User
26/02/2018 - 07:52
okay i want to solve the equation
Excelchat Expert
26/02/2018 - 07:53
you mean how to write the 10^-pH equation on column B?
Excelchat Expert
26/02/2018 - 07:55
a bit explanation please, seems like this is a math problem.
Excelchat Expert
26/02/2018 - 07:55
And I have minimal knowledge in math.
User
26/02/2018 - 07:57
are there any excel tools i could use to solve?
User
26/02/2018 - 07:57
and then graph?
User
26/02/2018 - 07:57
no it's chemistry
User
26/02/2018 - 07:58
but essentially i'm trying to get excel to solve
User
26/02/2018 - 07:58
just use the values in column A into the equation in B1
Excelchat Expert
26/02/2018 - 07:58
As an excel expert I can implement the calculations, I'm not aware of any tools that might use chemists in excel.
User
26/02/2018 - 07:58
it's just an equation solver
Excelchat Expert
26/02/2018 - 07:58
column A is the variable, right?
User
26/02/2018 - 07:58
can't excel calculate
User
26/02/2018 - 07:59
yes
Excelchat Expert
26/02/2018 - 07:59
Okay, the the result it the 10 exponential to minus value of pH, right?
User
26/02/2018 - 08:01
yes
Excelchat Expert
26/02/2018 - 08:02
if that's true then this is the required equation of excel =POWER(10,-A2)
User
26/02/2018 - 08:02
are u calculating by yourself or by excel
User
26/02/2018 - 08:02
ohhhh
Excelchat Expert
26/02/2018 - 08:02
Excel
Excelchat Expert
26/02/2018 - 08:02
=POWER(10,-A2)
User
26/02/2018 - 08:02
so is that supposed to go into B1
Excelchat Expert
26/02/2018 - 08:02
this is the formula I used here.
Excelchat Expert
26/02/2018 - 08:03
I'm sorry? what supposed to go into B1?
User
26/02/2018 - 08:03
how would u implement that
User
26/02/2018 - 08:03
the =POWER(10,A2)
User
26/02/2018 - 08:03
do i have to do it for each cell
Excelchat Expert
26/02/2018 - 08:04
So, you write =POWER is a cell where you want to calculate the result.
User
26/02/2018 - 08:04
or can i put that into B1 and then drag
Excelchat Expert
26/02/2018 - 08:04
You can put it in the first cell
Excelchat Expert
26/02/2018 - 08:04
Then drag it down.
Excelchat Expert
26/02/2018 - 08:04
I did that for the cells below.
User
26/02/2018 - 08:04
beautiful!
User
26/02/2018 - 08:04
thank you so much
Excelchat Expert
26/02/2018 - 08:05
My pleasure.
Excelchat Expert
26/02/2018 - 08:05
Anything else you want on this?
User
26/02/2018 - 08:05
no thank you
Excelchat Expert
26/02/2018 - 08:05
If not, please click on the End Session button to close the session and after that leave a feedback for me.
User
26/02/2018 - 08:05
you gotcha buddy
Excelchat Expert
26/02/2018 - 08:05
Thanks for choosing excel got it pro.
Excelchat Expert
26/02/2018 - 08:05
Have a great day!
User
26/02/2018 - 08:05
you a pro my friend
User
26/02/2018 - 08:05
shoutout to you
Excelchat Expert
26/02/2018 - 08:06
Do you need the file?
User
26/02/2018 - 08:06
yeoooo anon fox waddup
User
26/02/2018 - 08:06
no thank you
User
26/02/2018 - 08:07
i dont want an trojan horses
User
26/02/2018 - 08:07
you know these days
Excelchat Expert
26/02/2018 - 08:07
Understood
Excelchat Expert
26/02/2018 - 08:07
No worries.
Excelchat Expert
26/02/2018 - 08:07
Okay, a reminder - it is essential for you to close the session otherwise I'm stuck here and won't be able to help others.
User
26/02/2018 - 08:07
wanna trade emails
User
26/02/2018 - 08:07
oh
User
26/02/2018 - 08:07
my bad
User
26/02/2018 - 08:07
lol
User
26/02/2018 - 08:07
goodbye
Excelchat Expert
26/02/2018 - 08:07
THanks.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.