# Thread: Need help on if function.

1. ## Need help on if function.

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  Reply With Quote

=MIN(A1,12)  Reply With Quote

3. Not sure just give a try:

=IF(A1<=12,Value_If_True,12)  Reply With Quote

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

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 )  Reply With Quote

#### Posting Permissions

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