# Problem regarding IF Function.

1. ## Problem regarding IF Function.

Dear concern,

Would you please make me understand the below formula in a better way.

=IF(C2>=11000,IF(C2*50%<=6200,6200,C2*50%),IF(C2*60%<=3400,3400,C2*60%))

Regards
Shakil  Register To Reply

2. ## Re: Problem regarding IF Function.

Hi, welcome to the forum You have a series of nested IF()'s there

=IF(C2>=11000,IF(C2*50%<=6200,6200,C2*50%),IF(C2*60%<=3400,3400,C2*60%))
The 1st part is to test if C2>=11000, which will produce a TRUE or FALSE result

if TRUE, do the 1st of the next 2 IF()'s...
IF(C2*50%<=6200,6200,C2*50%)
This 1st tests to see if half of C2*50% <= 6200, if it is, it uses 6200, otherwise it used half of C2

If C2 < 11000, it does the last IF()...
This 1st tests to see if C2*60%<=3400, if it is, it uses 3400 otherwise it uses C2*60%

This could also have been shortened to this...
=IF(C2>=11000,MAX(6200,C2*50%),MAX(3400,C2*60%))  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 