**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.*