Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Brackett Series - Excel sheet

  • 25-02-2014 9:52am
    #1
    Smythe
    Registered Users, Registered Users 2 Posts: 434 ✭✭


    I want to produce a simple Excel sheet to calculate the wavelengths of H atom transitions and calculate, in nm, the first 4 lines of the Brackett series.

    Would anyone know what is wrong with the Excel sheet I have attached?


Comments

  • #2
    Peemaccee
    Registered Users, Registered Users 2 Posts: 27 ✭Peemaccee


    the n-1 is wrong.

    it should be at =4 for each calc.

    The labelling seemed messed up, the range n was not defined,
    but I am assuming that wasn't the issue of your post.

    regards


  • #3
    dlouth15
    Registered Users, Registered Users 2 Posts: 1,169 ✭✭✭dlouth15


    Delete the n name from your list of defined ranges within Excel and redefine it. When I did this, the formulas worked and I got results consistent with the expected results.

    If you like I can post the my changed version of the spreadsheet.


  • #4
    dlouth15
    Registered Users, Registered Users 2 Posts: 1,169 ✭✭✭dlouth15


    attached spreadsheet also includes corrections by Peemaccee


Advertisement