Sorry, your formula didnt help..
let me start over, (and also change a few things , my bad)
and it must check the conditions in this order:
if D23 is a 0,
then activecell (e23) should be a 0, regardless of D24's
value.
if D24 is a 0,
then activecell (e23) should be a 0, regardless of whatever.
if D23 is a 6, then CHECK IF d24 is also a 6 (if true, e23= 6. if false,
e23= 5).
if B24 says ("*Road" / "*Bridge" / "*Highway" <-- the * is a wildcard)
then CHECK IF B23 is also a "*Road" or a "*Bridge" or a
"*Highway"
(it doesnt have to be the same as b24's word)
if true, activecell (e23) should be 1
if b24 is one of those words, but b23 is not, copy
D24's value.
(if neither is the case, check the next condition)
if L24 is 4, check if D24 is a 5 (if its true, make activecell a 5, if not,
check if D24 is a 6 (if true, make activecell a 6) , else
make it a 4.
if D23 is any other number, activecell(E23) should copy D24's value.
(welll, preferrably, i wouldnt want D23 or D24 to be less than 0 or higher
than 6, or have text in it, but that will just make the formula that much
more complicated. I'm pretty sure whoever uses my sheet will remember to keep
the D column's values within that range..)'
btw, one reason your formula didnt work is becuz you're combining numbers..
multiplying D23 and D24 , if i understand correctly.
maybe i shouldve mentioned that the numbers are actually variables (for
something else, outside of excel)
so combining numbers would screw everything up for me
do you think u can give this another wack pls?
or is my formula is as simple as it can get, for what i'm trying to ask?
(minus the newly learned wildcard thing)
if its not, could u possibly include the wildcard thing in your formula?
thanks
sry, that doesnt work..
your formula requires that d23 must be a 1, in order for the active cell to
result in D24's value.
if D23 is anything other than 1, the active cell doesnt change (remains a "0")
that isn't correct. (and srry, i'm gonna change up something else here)
The formula should allow D23 to be any value (except 0 or 6)
in order for the active cell (E23) to copy D24's value.
if D23 is a 0, activecell (e23) should be a 0, regardless of D24's value.
if D23 is a 6, activecell (e23) should CHECK IF d24 is also a 6 (if true, =
6. if false, = 5).
