I have a problem that has taken me many attempt to solve, all fruitless. I
have a long list of data and want to insert a reason code based on some
criteria.
In colounm Q there have been reasons imputed by others. In colounm R2 i
would liek a astatement to say "if the value of p2 is between -.04 and .
04and Q2 is blank, return the value 13, otherwise return what is in Q2. but
if colounm C2 is blank or has the letters "HPC" i also want to return a 13.
PLease help me on this thanks alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

What's the relationship between P2, Q2, and C2? Individually, the
logic flow for the first half of your request is easy enough, and so is
the part pertaining to C2. The question becomes: in dealing with P2
and Q2, at what point or under what circumstances should we generate a
result that considers C2?

Thanks for your help but i need to rethink the criteria b/c too often it will
wrongly put in an incorrect code. I need to rework the whole process inwhich
i go about this tast as there are no similar relationships between many of
the cells due to the nature of the entries. thanks for your help though. U
made me catch my own error before ive wasted too much time

Dave O wrote:
What's the relationship between P2, Q2, and C2? Individually, the
logic flow for the first half of your request is easy enough, and so is
the part pertaining to C2. The question becomes: in dealing with P2
and Q2, at what point or under what circumstances should we generate a
result that considers C2?


--
Message posted via http://www.officekb.com

try
=if(or(and(P2-.04,P2<.04,Q2=""),C2="",C2="HPC"),13,Q2)

"JOn Kunces via OfficeKB.com" wrote:

I have a problem that has taken me many attempt to solve, all fruitless. I
have a long list of data and want to insert a reason code based on some
criteria.
In colounm Q there have been reasons imputed by others. In colounm R2 i
would liek a astatement to say "if the value of p2 is between -.04 and .
04and Q2 is blank, return the value 13, otherwise return what is in Q2. but
if colounm C2 is blank or has the letters "HPC" i also want to return a 13.
PLease help me on this thanks alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

One way:

R2: =IF(OR(C2="",C2="HPC",AND(ABS(P2)<=0.4,Q2="")),13, Q2)



In article ,
"JOn Kunces via OfficeKB.com" wrote:

I have a problem that has taken me many attempt to solve, all fruitless. I
have a long list of data and want to insert a reason code based on some
criteria.
In colounm Q there have been reasons imputed by others. In colounm R2 i
would liek a astatement to say "if the value of p2 is between -.04 and .
04and Q2 is blank, return the value 13, otherwise return what is in Q2. but
if colounm C2 is blank or has the letters "HPC" i also want to return a 13.
PLease help me on this thanks alot