need help simplying my formula..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
This is an Access newsgroup. You seem to be asking an Excel question. I'd
sugget you post to an Excel newsgroup.
 
Back
Top