# Excel - COLUMN Function Problem - Expert Solution

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
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
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
User 26/02/2018 - 08:07
oh
User 26/02/2018 - 08:07
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.