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

Excel Interp function

  • 18-04-2008 1:14pm
    #1
    TheBazman
    Registered Users, Registered Users 2 Posts: 6,462 ✭✭✭


    Hi all

    I have two spreadsheets where I am using the interp function.

    =interp(X1:X10,Y1:Y10,Z) where X is an ascending list of dates, Y is a list of numbers and Z is a date. Problem is I get a result on one spreadsheet, but a #NAME? error on the other. Given they are both open on the same Excel all add-ins and options are set the same.

    When I click on the Function button to see more detail I get
    On the one that is working:
    Array Days = a series of dates (ie) giving a result)
    ArrayRates= a series of numbers
    Days = a result day
    And underneath it says ArrayDays in bold with a formula result

    On the one that is not working:
    Array Days = a series of dates (ie) giving a result)
    ArrayRates= a series of numbers
    Days = a result day
    And underneath it says Undefined and no formula result

    This is really wrecking my head. Is there any reason why there would be a problem with one and not the other given they are exactly the same inputs, format, settings, formula etc?

    Cheers


Comments

Advertisement