Issue I’m wondering how I can check if a string contains either “value1” or “value2”? I tried this: If strMyString.Contains(“Something”) Then End if This works, but this doesn’t: If strMyString.Contains(“Something”) or (“Something2”) Then End if This gives me the error
Continue readingTag: if-statement
[SOLVED] Change the value of a cell according to the font colour of another cell
Issue I would like to change the value of a cell depending on the font color of another cell. In three adjacent columns I have three different values. On one of the cells I have a value with green font.
Continue reading[SOLVED] New Column with multiple conditions and/or between different columns (strings)
Issue Im stuck. im tryin to code this excel formula in a code of python but after searchin and tryin diff codes i cant get the solution. =+IF(AND(K2="inscrito_registro")*OR(L2<>"inscrito_registro")*OR($L2<>"no_necesario")*OR($L2<>""),"con carga","sin carga") I tried with this code in python but its not
Continue reading[SOLVED] skip worksheet if pattern not found
Issue I have a multiple worksheet Excel file. I want to copy a range enclosed between cells with the values "start" and "next" from each worksheet to a "master" worksheet. This range will be at different addresses for each sheet.
Continue reading[SOLVED] Assistance with duplication values in excel
Issue I’ve got an excel sheet here where I’m trying to see if I need to apply a user license, device license, or none, and this is based on whether or not there are duplicates within a column. For example,
Continue reading[SOLVED] MongoDB script creates an empty object when it finds a null object instead of ignoring it, how can I fix this?
Issue I have a large script, the following section is the relevant part, but if people prefer I can post the whole script on request. The script iterates through a list, looking for a field called colour and renames it
Continue reading[SOLVED] How to use the IF statement to avoid the Weather API fetch result crashing once the user types wrong the city name?
Issue Summarizing The Problem – Details About The Goal A weather app that renders on the screen the data fetched from OpenWeather API. – Actual and Expected Results Whether the user types correctly or not the city name or presses
Continue reading[SOLVED] How to specify a less than today condition on a date in Rails ActiveRecord
Issue I’m trying to figure out how to pull all the records in my set where their fields publish is true and expires is less than today. I have the following but I don’t think the less than part is
Continue reading[SOLVED] Efficient conditional statement to hide certain layout elements (navbar/footer) on root
Issue I posted a similar question here. It may seem duplicated but this question is different in that I specifically want a conditional statement to remove a portion of the layout (not the entire file) I have tried: if current_page?(root_path)
Continue reading[SOLVED] Loop through a string with variable and replace an uppercase it with # in Python
Issue I want to loop through a string and when it finds an uppercase letter, I want to replace it with #. Like this: string = "hOw Are yOu?" for x in string: if x.isupper(): string.replace(x, "#") print(string) else: print(string)
Continue reading