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