Need help on if function.

Abhishek Ghai

New member
Joined
Jul 7, 2012
Messages
5
Reaction score
0
Points
0
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

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
How about

=MIN(A1,12)
 

Rizky

New member
Joined
Apr 28, 2014
Messages
44
Reaction score
0
Points
0
Not sure just give a try:

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

Abhishek Ghai

New member
Joined
Jul 7, 2012
Messages
5
Reaction score
0
Points
0
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
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
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
:whistle:)
 
Last edited:
Top