Electron energy levels in Bohr model

[ZedCar]

Homework Statement

At the bottom of this linked-to screen below is an equation for E = - ... = - .... = - 13.6 Z^2 / n^2 eV

https://en.wikipedia.org/wiki/Bohr_model#Electron_energy_levels

Homework Equations

I'm using the following values for the formula

Z=1
n=1
K sub e = 8.987 x 10^9 (Coulombs constant)
e = 2.71828
m sub e = 9.11 x 10^-31 (mass of electron)
h-bar = 1.05 x 10^-34

The Attempt at a Solution

But when I plug these values in I get (4.017x10^-9) / (2.205 x 10^-68) = - 1.82 x 10^59

and not -13.6 eV

What am I doing wrong? Are any of my values above incorrect?

 

[TSny]

You have misinterpreted the meaning of e in the equation.

 

[ZedCar]

Thanks TSny!

 

[ZedCar]

I'm trying to write a simple Excel program to allow use of that formula.

I've included my program and the formula in the Excel attachment. Would anyone know why I'm getting the VALUE! message in the A5 box?

 

[voko]

Your data values are interpreted as text, not as formulae. Add = in front of them. Also, make sure you format the result cell as a scientific number, otherwise it will just display 0.

 

[ZedCar]

Thanks voko!

 

[ZedCar]

I've attached the updated Excel file again.

The cell A5 displays the value in eV, currently set for n=1.

If I want to obtain the different values of Energy but for each of the values of n between 1 and 10 inclusive, how would I do this?

 

[voko]

This question has very little to do with physics and much to do with using Excel. You should be asking in a more appropriate section of the forum.

Your question is very basic. There are probably a lot of online tutorials addressing that.