+ Reply to Thread
Results 1 to 5 of 5

URGENT HELP NEEDED Nested IF Functions Using Text in Excel 2010

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    8

    URGENT HELP NEEDED Nested IF Functions Using Text in Excel 2010

    Hi

    Can anyone help me, i'm trying to put together a nested IF formula and it looks like this at the moment

    =IF(A28="standard carer hourly rate",10.16,IF(A28="registered nurse rate",15.24,IF(A28="waking night carer rate",12.7,IF(A28="Enhanced Carer Hourly rate",11.43,0))))

    It works for all the options on the validated drop down menu except Enhanced Carer Hourly Rate which always comes back as 0 rather than 11.43. I really can't see where I've gone wrong and I've checked spellings as well it's very frustrating as it works perfectly for the other choices.

    Can anyone help?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,077

    Re: URGENT HELP NEEDED Nested IF Functions Using Text in Excel 2010

    Formula looks ok apart from you have capital letter in "rate" though that shouldn't affect things normally.

    Can you post a dummy spreadsheet?
    Copy the dropdown and formula to a blank spreadsheet.
    or

    in your dropdown change the values to S R W and E
    Then change the descriptions in your formula to S R W and E
    If it now works then its spelling differences between the dropdown and the formula.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    08-08-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: URGENT HELP NEEDED Nested IF Functions Using Text in Excel 2010

    I tried the S, R, W, E and it works, so clearly my spell checking isn't as great as i thought. I will retype the text and see if that works. Thank you for your quick response

  4. #4
    Registered User
    Join Date
    08-08-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: URGENT HELP NEEDED Nested IF Functions Using Text in Excel 2010

    Thank you it worked perfectly, although i feel a bit stupid as it was something simple like spelling haha

  5. #5
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,077

    Re: URGENT HELP NEEDED Nested IF Functions Using Text in Excel 2010

    No worries, it's a common Excel problem :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help With Nested IF Functions Excel 2010
    By mrsdeapsleap in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-24-2014, 02:17 PM
  2. Nested IF function (urgent help needed)
    By HJalal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2013, 11:59 AM
  3. How Many Nested IF Functions Can Excel 2010 Handle
    By boohah in forum Excel General
    Replies: 4
    Last Post: 01-08-2013, 06:16 PM
  4. Help needed with annualizing data - urgent - Excel 2010
    By pcoty1953 in forum Excel General
    Replies: 0
    Last Post: 05-15-2012, 02:32 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1