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
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
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%))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks