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