Results 1 to 5 of 5

Thread: Need help on if function.

  1. #1

    Question Need help on if function.

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please correct me if I am wrong. I am using IF function to return a value in a cell where value required should be either =12 or less than 12.

    This value I need will help me callculate interest earned over 12 months or less than 12 months.

    I am using multiple IF function and got stuck in the second if, where I don't know how to get the <12 value in the true field,




  2. #2
    How about


  3. #3
    Not sure just give a try:


  4. #4
    Thanks to both of you. The Min formula worked fine but Rizky the other one didn't work, but really appreciate your help.

  5. #5
    I think that Rizky didn't make the assumption that I made and so didn't know what you wanted for Value_if_True. I think that if you use


    it will work (but not as good as mine
    Last edited by Bob Phillips; 2014-09-16 at 12:29 PM.

Posting Permissions

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