LinkBack URL
About LinkBacks
Hello
I have a problem with a formula, one of the conditions are not working and is writing FALSE instead of the condition.
Please find attached the file
Best regards,
John
Hello
I have a problem with a formula, one of the conditions are not working and is writing FALSE instead of the condition.
Please find attached the file
Best regards,
John
can you explain to me, in words, what you are trying to do please? your formula construction is ummm....unconventional
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
Haha ok sorry about that
So here are the conditions:
IF cell<100%, then 100%;
IF 100%<=cell<110% then 110%
IF 110%<=cell<120% then 120 %
IF cell>=120% then minimum between (cell and 148%)
Regards
John
try this....
=IF(C6<=1,1,IF(AND(C6>1,C6<=$F$1),$F$1,IF(AND(C6>$F$1,C6<=$F$2),$F$2,IF(C6<$F$3,C6,$F$3))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks