Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

MS-Excel question (simple)

  • 08-02-2014 05:24PM
    #1
    Smythe
    Registered Users, Registered Users 2 Posts: 434 ✭✭


    The column for variable E (J column) uses the equation as shown in the top left of the Excel sheet.

    This column uses different values of n from 1 - 10.

    If I want to extend the 'n' column (column I) down to greater values past '10', I can drag on this and it creates greater values for n.

    However if I want to lengthen the column for the variable E (column J) when I drag on it a VALUE! message is displayed.

    Would anyone know why? Thanks


Comments

  • #2
    Smythe
    Registered Users, Registered Users 2 Posts: 434 ✭✭Smythe


    I have this sorted now.


  • #3
    namenotavailablE
    Registered Users, Registered Users 2 Posts: 59,780 ✭✭✭✭namenotavailablE


    Two tips:

    You should consider defining N using the OFFSET() function to allow it to dynamically expand and contract. In the Name manager, entering this formula should achieve that:

    =OFFSET(Sheet4!$I$3,0,0,COUNTA(Sheet4!$I:$I)-1,1)


    I'd also suggest that cell I4 in your example uses this formula: =I3+ISFORMULA(J4)

    Free Excel net pay calculator- https://taxcalc.eu/monthlyss/Employee%20PAYE%20calculator.xlsm



Advertisement