-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
thanks!
-
If formula, with a twist
I have an if formula that has a variable. I'd like to search for a keyword (diesel) and if it is found, return a string. I thought about IF(F23="*diesel",S$33 but that didn't work. Any ideas?- HeRoseInThree
- Thread
- formula please help please help me thank you! thanks in advance!!! thanks!
- Replies: 35
- Forum: Excel Questions
-
The first part of this formula works, but not the rest.
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...- HeRoseInThree
- Thread
- help please help please help me thanks for the help thanks in advance!!! thanks!
- Replies: 6
- Forum: Excel Questions
-
I don't know what to call it. That's why I cant Google it : )
First Name Last name Suffix Complete name Last, First Phone DOB Hire Term SSN Tenure Phone SSN Age john doe jr John Doe Jr Doe, John 8158675309 5/21/73 11/28/2017 123-45-6789 2 years, 11 months, 5 days (815) 867 - 5309 6789 47 If I enter a date in the term column (j2) is there a way to...- HeRoseInThree
- Thread
- help please help please help me thanks in advance!!! thanks!
- Replies: 3
- Forum: Excel Questions
-
C
Help with Loop Without Do Error
Hi guys, I've been trying to fix this VBA code (that a previous employee left us), but since I have no experience in VBA, I can't seem to figure it out. Would anyone of y'all be able to help me out? Sub categorization3a() Application.ScreenUpdating = False 'further segment PRODUCT row =...- Coltaine
- Thread
- excel loop without do thanks! vba
- Replies: 1
- Forum: Excel Questions
-
V
Compilation error : BLOCK IF WITHOUT END IF
If ((char = ",") And (cou >= 10)) Then add = add + char + vbNewLine c = 1 cou = 0 Else add = add + char c = 0...- Vidush
- Thread
- compile error help me ifelse thanks! vba
- Replies: 5
- Forum: Excel Questions
-
F
Update existing hyperlinks automatically when changing the folder name linked documents are saved under
Dear Forum members,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am desperately looking for some advice from you Excel experts!<o:p></o:p> At work we are using an excel spreadsheet as a project checklist during the project execution phase...- ftischer
- Thread
- folder modification folder structure help needed hyperlinks thanks!
- Replies: 4
- Forum: Excel Questions
-
S
disabling the info / warning messages!!!
hi, pls help me disabling the prompt msg that encounter during the macro is running for eg - sheet is protected etc. secondly I wanted to know if i am asking user to input a no. in a input box but if the user presses cancel button insead of pressing ok then their should not be any error. it...- soodaarti21
- Thread
- thanks!
- Replies: 3
- Forum: Excel Questions
