conditional formula needed
any thoughts on this?
"kylefoley2000" wrote:
it might be possible to do this as a conditional formula (=if) otherwise a
macro might be needed.
the thing i'm unsure about is this formula looks at the cells beneath it and
keeps looking until a result is returned, i'm not sure if that can be done as
a conditional formula.
if you really want to know what this is for send me a pm and i'll tell you.
if m3 = 0 then ""
if l3 = i then ""
if m3 = 1 and if l3 = "c" and if i3 0
and if e4 €“ d3 < -.0066 then result = 1
write result in n3
else go to row 5
if e5 €“ d3 < -.0066 then result = 1
if d5 = d3 then result = 0
i seriously doubt this will happen but in case it does
if e5 €“ d3 < -.0066 and if d5 d3 then result = "ambiguous"
else go to next row
keep going down the rows (it should not take any more than 3 or 4) until
either
if i3 < 0
and if e4 €“ d3 .0066 then result = 1
write result in n3
else go to row 5
if e5 €“ d3 .0066 then result = 1
if d5 < d3 then result = 0
must loop through all the rows, there 8800 of them
|