N
Nick Xylas
Once again, I need the help of the clever people on this group in
parsing a formula. Here's the setup:
Cell A1 is the cell the formula goes in.
If cell AA7 equals the text value "YES" (itself the result of a
calculated formula), then A1=1.
If cell AA7 is zero, and AB7 contains an asterisk (again the result of
a calculated formula), then A1 is left blank.
If AA7 is zero and AB7 is blank, the A1=0
If AA7 contains any other numeric value besides zero, then that value
is reproduced in A1.
AB7 either contains an asterisk or is left blank, so testing whether
AB7="*" or testing whether it is nonblank will both work equally as
well.
Thanking you in advance.
parsing a formula. Here's the setup:
Cell A1 is the cell the formula goes in.
If cell AA7 equals the text value "YES" (itself the result of a
calculated formula), then A1=1.
If cell AA7 is zero, and AB7 contains an asterisk (again the result of
a calculated formula), then A1 is left blank.
If AA7 is zero and AB7 is blank, the A1=0
If AA7 contains any other numeric value besides zero, then that value
is reproduced in A1.
AB7 either contains an asterisk or is left blank, so testing whether
AB7="*" or testing whether it is nonblank will both work equally as
well.
Thanking you in advance.