+ Reply to Thread
Results 1 to 11 of 11

IF formula help

  1. #1
    Registered User
    Join Date
    09-16-2015
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    6

    IF formula help

    Could someone please tell me why the following formula is returning false?

    excel1.JPG

    excel2.JPG

    any help is greatly appreciated

  2. #2
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: IF formula help

    Hii welcome to forum... formula not visible please attach sample workbook highlighting desired result...
    Don`t care, take care...

    Regards,
    Mangesh

  3. #3
    Registered User
    Join Date
    09-16-2015
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    6

    Re: IF formula help

    Thanks mate,

    Can you not see the two images? The first image that I can see has the formula in the formula bar.

    cheers

  4. #4
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: IF formula help

    Yes but It is always good practice to attach sample workbook instead of attaching image which will save time of forum contributors...

  5. #5
    Registered User
    Join Date
    09-16-2015
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    6

    Re: IF formula help

    I'm not sure what you mean. Do you want the whole workbook? Unfortunately the information in it is classified to our business. Are you able to help from the images?

    Thanks Mangesh

  6. #6
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: IF formula help

    I dont want whole workbook just sample....

    Hope this will work...
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You can remove Sum only 3650.09+2559.29 will work... I kept it for safer side
    Last edited by mangesh.mehendale; 09-16-2015 at 01:09 AM.

  7. #7
    Registered User
    Join Date
    09-16-2015
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    6

    Re: IF formula help

    Thank you very much Mangesh, I will work with what you have given me.

    Thanks for your time.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: IF formula help

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  9. #9
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: IF formula help

    If done mark this thread as solved see at top(in Thread Tools)...

    Also hit on "Add Reputation" to the answer if someone help you in this forum....

  10. #10
    Registered User
    Join Date
    09-16-2015
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    6

    Re: IF formula help

    Quote Originally Posted by FDibbins View Post
    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    No problem. The reason I just posted pictures was because I thought my formula was solid with just syntax problems that could be easily seen by someone who knows a lot more than me. Thanks for your time.

  11. #11
    Registered User
    Join Date
    09-16-2015
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    6

    Re: IF formula help

    Quote Originally Posted by mangesh.mehendale View Post
    If done mark this thread as solved see at top(in Thread Tools)...

    Also hit on "Add Reputation" to the answer if someone help you in this forum....
    Thanks mate. The formula is still not working but you have given me something better to work with. I can't spend anymore time on this formula until later but I will be sure to closeout when finished.

    Thank you

+ 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. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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