The first part of this formula works, but not the rest.

[HeRoseInThree]

The first 4 parts work, but none of the rest. Any ideas why?

=IF(ISBLANK(A19),"",IF(A19="tow","Towing",IF(A19="etow","Emergency roadside towing",IF(A19="itow","In house towing",IF(A19="inspect","Inspect to determine necessary repairs",IF(A19=”dot”,"DOT re-inspection fee",IF(A19=”scene”,"Clean up at scene",IF(A19="prop","Other real property damaged",IF(A19="wc","Subrogation for W/C injury",IF(A19="gas","100 gallons of fuel @ $2.87",IF(A19="parts","misc parts",IF(A19="ship","Shipping for parts",IF(A19="cool","Reclaim refrigerant, replace and perform leak check",IF(A19="fea","Front end alignment",IF(A19="h20","12 gallons of antifreeze @ $6.73",IF(A19="bodyp","Body shop (parts & materials)",IF(A19="bodyl","Body shop (labor)",IF(A19="misc","Misc shop procedures, supplies & administrative fees",IF(A19="report","Purchase accident report",0)))))))))))))))))))

 

[Fluff]

Some of your quotes are wrong you have ” rather than "

 

[HeRoseInThree]

Sorry, but I do not see what you are talking about.

 

[Fluff]

Look at the quotes you have here

IF(A19=”dot”,

they are the wrong type, you need to change them to "
You also have them around

IF(A19=”scene”

 

[HeRoseInThree]

OK, I'm 48 years old, been working with computers for most of my life and I went to DeVry. I NEVER knew there was a difference in the quotes!

THANKS!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[HeRoseInThree]

Sure thing! You did the hard part, it is the least I could do!