Hello, this is my first post on anything so here goes.
<style type="text/css">P { margin-bottom: 0.08in; }</style> column G represents a range of values (i.e. 10 to 90) of which I'm trying to key on one of several possibilities; ( 12,13,19,24,60,61,62,63,64,65,66,67,68,or 72)
columns C and M represent values ($0.00 to $x.00), either C or M but not both may hold a value in the same row
as an example:
if column G=64 and C<>0, I would like column X to result in C's value;
if G=64 and C=0, I would like column X to result in M's value;
if column G does not match any of the selected values, column X should result in a blank
Thank you in advance for any assistance in this problem.
Erin
<style type="text/css">P { margin-bottom: 0.08in; }</style> column G represents a range of values (i.e. 10 to 90) of which I'm trying to key on one of several possibilities; ( 12,13,19,24,60,61,62,63,64,65,66,67,68,or 72)
columns C and M represent values ($0.00 to $x.00), either C or M but not both may hold a value in the same row
as an example:
if column G=64 and C<>0, I would like column X to result in C's value;
if G=64 and C=0, I would like column X to result in M's value;
if column G does not match any of the selected values, column X should result in a blank
Thank you in advance for any assistance in this problem.
Erin