How about
=MIN(A1,12)
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
How about
=MIN(A1,12)
Not sure just give a try:
=IF(A1<=12,Value_If_True,12)
Thanks to both of you. The Min formula worked fine but Rizky the other one didn't work, but really appreciate your help.![]()
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 01:29 PM.
Bookmarks