sry, i messed up on the 2nd q...
i meant this:
this is for E23:

=IF(D23=0,
T: 0,
F: IF(D24=0,
T: 0,
F: IF(B24="Road",
T: IF(B23="Road",
T: 1,
F: D24),
F: IF(L24=4,
T: IF(D24=5,
T: 5,
F: IF(D24=6,
T: 6,
F: 4)),
F: IF(D23=6,
T: 5,
F: D24)))))

i hope that makes sense..
(this is excluding the stuff from question1)

at some point in that formula it says:
if (cell) = 6 ,
TRUE: 6
FALSE: if (cell) = 5,
TRUE: 5
FALSE: (something else)

can i write something like...
if <cell = (6,5) , (6,5)

or.. i donno

"Don Guillett" wrote:

Maybe?????? 2nd question
=min(a1,c2)

--
Don Guillett
SalesAid Software

"Mo2" wrote in message
...
for cell D25:
=IF(A25=0,0,IF(RIGHT(B25,4)="Road","Road",IF(RIGHT (B25,6)="Bridge","Road",IF(RIGHT(B25,7)="Highway", "Road"))))

this means that, B25 could be "Bay bridge", "County Road", "Blue Highway",
etc etc
and the result for D25 would be "Road"

is there a simpler way of writing this formula?

2nd question:
for cell B5
IF(A1=0,0,IF(C2=4,IF(A1=5,5,IF(A1=6,6),A1)))

can i write this any simpler?

tia