LinkBack URL
About LinkBacks
Hi All,
in addition to my earlier post, i have a column: Column X that will show proceed if:
column R = No
Column S = No
Column U = YES
Column V = Yes
and will show Do not proceed if:
Column R and Column S = YES
Thanks again!
Hi All,
in addition to my earlier post, i have a column: Column X that will show proceed if:
column R = No
Column S = No
Column U = YES
Column V = Yes
and will show Do not proceed if:
Column R and Column S = YES
Thanks again!
Not sure where your earlier post is so I'm simply going with what you've posted here
(if this is a continuation of another thread you should have posted to the same thread).
=IF(AND(R1="No,S1="No",U1="YES",V1="Yes"),"P","Do Not P")&"roceed"
should suffice
Last edited by Special-K; 01-29-2015 at 07:25 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
May be:
=IF(R1&S1="YESYES","Do not process",IF(R1&S1="NONO",IF(U1&V1="YESYES","Process",""),""))
Quang PT
Hi bebo021999, tried ur rformula but shows me a blank result. let me rephrase the needed criteria.
IF
column R = Yes
Automatic it will show Do not proceed.
If column R = No
and Column S = Yes
It will still show do not proceed
If Column R = No
Column S = No
Column U = No
Column V = Yes
Still do not proceed
It will still show do not proceed
If Column R = No
Column S = No
Column U = yes
Column V = no
Still shoe do not proceed
and if
If Column R = No
Column S = No
Column U = yes
Column V = YES
Then it will show proceedSOrry for the long post
Basically only show proceed if R = No S = No U=Yes and V= Yes
Check my formula again, I've just edited it.
Hi Special K,
yes thats correct. It will only proceed in that way. I have checked your formula and its kinda not in order, can you double check?
This is ur formula as seen above:
Please Login or Register to view this content.
Hi Special K, Sorry my excel's fault. I entered your fromula and it works
Thanks!!
How about:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks