Hi,
The formula works correctly for the Countif formula but not for the If formula part.
How do i change formula to work...please see attached workbook
Regards
Andy
Hi,
The formula works correctly for the Countif formula but not for the If formula part.
How do i change formula to work...please see attached workbook
Regards
Andy
Try this out:
=IF(OR(A6="T",B6="T"),4,IF(AND(C11="T",D11="T",F11="T"),6,0))
Last edited by Glenn Kennedy; 09-01-2016 at 11:11 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Do the test for A6, B6 first...
=IF(OR(A6="T",B6="T"),4,IF(COUNTIF(Sheet1!C11:D11,"T")+(Sheet1!F11="T")=3,6,0))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try this...........=IF(OR(A6="T",B6="T"),4,IF(AND((C11="T"),(D11="T"),(F11="T")),6,0))
Ash
Thanks Glenn & Ash Maverick & Tony Valko
Very close..only change...If i remove the "T" from C11 or/and D11 then result should = 0 even if there is a "T" in either A6 or B6 or both
Thanks
Last edited by andy_tap; 09-01-2016 at 11:15 AM.
This is working for me..........=IF(OR(A6="T",B6="T"),4,IF(AND((C11="T"),(D11="T"),(F11="T")),6,0))
oh sorry...............got it...........u r saying that if removed from C11 or D11 then the result shud be zero
That is not what you asked for. I interpreted this:
"if "T" in C11:D11 & F11 then =6 "
as meaning T in ALL 3 cells, then 6. Can you re-explain your criteria?
you never mentioned that anywhere
Ash's formula is (in effect) identical to mine. How can it be correct and mine incorrect. Now I really am confused!!!
no no............he says mine is also not correct
*incorrect
I think this should do it. Now you get 0 if one of C11, D11 or F11 is blank.
I'm getting my Ash's and Andy's mixed up....
Apologies...
"if "T" in C11:D11 & F11 then =6 " ... yes this is correct.....if then there is a "T" in either A6 or B6 then = 4 ...that worked correctly as well in the formula...
The formulas posted were correct in there result except i missed saying that if either C11 and D11 are empty then result = 0
The attached workbook should = 0 as C11 is blank...if d11 was blank and C11 has a "T" should also = 0
Thanks
Last edited by andy_tap; 09-01-2016 at 11:26 AM.
Try this............=IF(OR(C11<>"T",D11<>"T"),0,IF(OR(A6="T",B6="T"),4,IF(AND((C11="T"),(D11="T"),(F11="T")),6,0)))
Thanks Ask.....works fine
Thank you to all others as well
Good deal. Thanks for the feedback!
You are welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks