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