+ Reply to Thread
Results 1 to 5 of 5

=IF Statement not functioning properly

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    25

    =IF Statement not functioning properly

    Evening All,

    i have to cells running =IF (D29 & D31) , D29 is for if the value of N14 is equal to or less than 35999.99 (if it is more to display 0) & D31is for if the value of N14 is equal to or greater than 36000 (if it is less to display 0).

    the Formula in D29 is =IF(N14<="35999.99",SUM(B29/100*20)+(B29/100*12),"0")

    the Formula in D31 is =IF(N14>="36000",SUM(B29/100*40)+(B29/100*12),"0")

    any help in this matter would be greatley appriciated.

    Cheers
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: =IF Statement not functioning properly

    & is the string concatentate operator in excel formulae. I think you want AND(d29,d31).
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Registered User
    Join Date
    06-06-2012
    Location
    Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: =IF Statement not functioning properly

    Sorry PauleyB,

    Im fairly new to Excel & i dont quite understand, could you please provide me with the for formula i require for cells D29 & D31 or edit the workbook so i can see what you mean.

    But many thanks for the quick reply

  4. #4
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: =IF Statement not functioning properly

    I had to re-read your post a few times to figure out what you are asking. I thought you wanted a formula using =if(and(d29,d31),...,...). Now I see those were the cells using the if formulae and those are failing.

    They are not working since you are putting numbers in quotes. That makes excel look at them as text strings. Remove the quotes around all of your numbers in the formulae and see what happens.

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

    Re: =IF Statement not functioning properly

    Try this

    in D29
    =IF(N14<36000, B29/100*20+B29/100*12,0)

    in D31
    =IF(N14>=36000,B29/100*40+B29/100*12,0)

    You dont need SUM since you're not SUMming anything, its just a multiplication/division calculcation

    By the way you could also say this
    in D29
    =IF(N14<36000, B29/100*32,0)

    in D31
    =IF(N14>=36000,B29/100*52,0)
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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