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,

    =IF(A1>12,12,IF(A1<12,<value_if_True,<Value_if_False))

    Regards

    Abhishek

  2. #2
    How about

    =MIN(A1,12)

  3. #3
    Not sure just give a try:

    =IF(A1<=12,Value_If_True,12)

  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

    =IF(A1<=12,A1,12)

    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
  •