Need help on if function.

Abhishek Ghai

New member
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

Staff member

=MIN(A1,12)

Rizky

New member
Not sure just give a try:

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

Abhishek Ghai

New member
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

Super Moderator
Staff member
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: