LinkBack URL
About LinkBacks
If T4=TRUE and T23, T24, T25, T26 (any of these = true) = C10
If T4=TRUE AND T6=TRUE and T23, T24, T25, T26 (any of these = true) = L9
If T6=TRUE and T23, T24, T25, T26 (any of these = true) = L9
Hope this makes sense. Thanks for help!!
If T4=TRUE and T23, T24, T25, T26 (any of these = true) = C10
If T4=TRUE AND T6=TRUE and T23, T24, T25, T26 (any of these = true) = L9
If T6=TRUE and T23, T24, T25, T26 (any of these = true) = L9
Hope this makes sense. Thanks for help!!
are you asking us to write a formula which captures all that logic? a sample workbook would most likely help explain your request. also, your title could probably be more descriptive. i'm assuming the last = in each of your three expressions is a "then" in that line's if, then statement. also, i'm assuming you want to check the first set of criteria first, and if that is not true then move on to the second and then third.
Formula:
=if(and(t4,or(t23,t24,t25,t26)),c10,if(and(t4,t6,or(t23,t24,t25,t26)),l9,if(and(t6,or(t23,t24,t25,t26)),l9,"none of these three conditions are met")))
untested
Yes - and thank you. The formula you provided works great except for one problem. when t4 and t6 are both true it is showing the value in c10 instead of L9. Thank you very much for your help!
Do those cells actually contain the word TRUE, or what is in them?
If T4=TRUE and T23, T24, T25, T26 (any of these = true) = C10
If T4=TRUE AND T6=TRUE and T23, T24, T25, T26 (any of these = true) = L9
If T6=TRUE and T23, T24, T25, T26 (any of these = true) = L9
=IF(AND(T4=TRUE,countif(T23:T26,True)>0),C10,IF(AND(T6=TRUE,countif(T23:T26,True)>0),L9,IF(AND(T4=TRUET6=TRUE,countif(T23:T26,True)>0),"")
Or maybe
=IF(countif(T23:T26,True>0),IF(T6=TRUE,L9,C10),"")
your 2nd 2 rules will both give L9 if T6 is TRUE, so rule 2 is kinda redundant
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
Yes - the cells are linked to check boxes.
OK, so did you try the suggestions?
Working on your suggestion right now. thanks!
and if nothing is checked can it report a 0 instead of FALSE?
So it works like the formula that was posted right before. So if I check T4 is returns the correct value. If I check T6 it returns the correct value. If I have them both checked it returns an incorrect value...it is returning C10 instead of L9
Perhaps its time to upload a small sample workbook for us, so that we can stop guessing
Excel Forum.xlsx
Did it attach?
Thanks.
Are we talking about testing for C4:C6 on its own and C9:C12 on its own, or C4:C12?
Also, why use check boxes, why not just have a cell to enter an x or something?
I inherited the worksheet...just trying to make it work with the checkboxes.
If test 1 is checked (true) and 1 or more of the 'Choices' is true then it would return the value $100.
If test 3 is checked (true) and 1 or more of the 'Choices' is true then it would return the value $200.
If test 1 and test 3 are both checked (true) and 1 or more of the 'Choices' is true then it would return the value $200.
If Test 1 or Test 3 are checked and no choice is selected = 0
Yes, that is the same rules you have in your workbook...
Are we talking about testing for C4:C6 on its own and C9:C12 on its own, or C4:C12?
I guess I don't understand what you are asking? sorry.
what is the difference between the 2 options: Are we talking about testing for C4:C6 on its own and C9:C12 on its own, or C4:C12?
Sorry, misunderstood, try this...
=IF(AND(C6,COUNTIF($C$9:$C$12,"TRUE")),G5,IF(AND(C4,COUNTIF($C$9:$C$12,"TRUE")),F5,""))
PERFECT!!! Thank you so much!!
As a possible alternative try this:
Formula:=IF(SUMPRODUCT(($C$9:$C$12)*$C$4*$C$6),$G$5,IF(SUMPRODUCT(($C$9:$C$12)*$C$6),$G$5,IF(SUMPRODUCT(($C$9:$C$12)*$C$4*NOT($C$6)),$F$5,0)))
Glad we got what you needed, thanks for the feedback
=MAX(INDEX((C4:C6=TRUE)*{100;0;200}*(COUNTIF(C9:C12,TRUE)>0),0))
Try this formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Good one, nflsales! Thanks for sharing.Originally Posted by nflsales
disregard - i didn't see the second page of responses. my solution was already covered.
Last edited by simarui; 12-10-2014 at 04:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks