need help simplying my formula..

M

Mo2

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
 
R

RBear3

This is an Access newsgroup. You seem to be asking an Excel question. I'd
sugget you post to an Excel newsgroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help simplying my formula.. 8
VBA for data validation in 3rd column does not run. I need help. 1
auto-hide rows, cell format (# and @), update cell refs, shade cel 0
Loop a long formula through range 2
Seriously need help with formula 3
help... i might need a macro for this.. (hiding a specific # of ro 7
Help needed - seriously (looping? macros? formulas?) 4
Formula help needed please 3

Top