Need help on if function.

[Abhishek Ghai]

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:boom:, 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

 

[Bob Phillips]

How about

=MIN(A1,12)

 

[Rizky]

Not sure just give a try:

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

 

[Abhishek Ghai]

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

 

[Bob Phillips]

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 )