All Questions
Tagged with excel if-statement
3,369
questions
0
votes
0
answers
9
views
How not to duplicate a complex expression in an if condition and the result expression in Excel [duplicate]
Frequently I want to check a complex condition and if valid, use the result as the result statement such as:
=IF(RC2+R1C>1.33,RC2+R1C,"")
Here, in a simple example, the RC2+R1C is ...
- 11
0
votes
1
answer
35
views
Excel Formula for Today's Month Being Greater Than Lookup Value Month & Provide Message
I have created a budget sheet in Excel to track Debt Snowball payments. I have a formula that successfully works to lookup the month from a list of months (column F) that a final payment is made for a ...
0
votes
0
answers
35
views
saving results according to conditions
I am trying to take the specific data I need from the loaded excel file,
I entered the conditions, where in the first condition it pulls out the cell, the cell where 'Entrance (number) Floor' is ...
0
votes
0
answers
48
views
Entered too many arguments for this function
I am having a problem where I am unable to find out the issue with my formula in Excel. Everything worked fine until I added an additional argument to the string, but I do not see any erroneous commas ...
-2
votes
1
answer
61
views
How can I run If statements on every sheet that contains specific text using VBA?
I am trying to create a macro that will run If statements on every sheet with "(M)" at the end. I just need the macro to check cell "G8" in every worksheet with "(M)" at ...
1
vote
3
answers
81
views
Excel Column to Count Unique Values
I have a list of names in a column in excel. The names are duplicated many times in the data. I want to create a new column that will put a 1 for each time a name first appears and 0’s after that. My ...
- 11
0
votes
1
answer
42
views
Multiple OR conditions in an AND formula
I'm trying to get a yes or no result from comparing certain items that could be the content of a cell (F2) with certain possibilities from (H2) and again from (K2).
If all the conditions are true then ...
2
votes
2
answers
77
views
I am getting an error Else If without If and don't understand why
I can't see the reason I am getting an error message Else If without If. Does it have something to do with the Msgbox? The problem is I had EXIT SUB after the first IF statement and then a regulur if ...
- 23
0
votes
1
answer
26
views
Excel VBA - how do I get the RowSource of a ComboBox to change depending on the value of another Combobox?
basically I'm trying to have two ComboBoxes that interact with each other in my UserForm.
The first one having a simple list of maybe ten things as it's RowSource. These ten things however work as ...
- 3
1
vote
5
answers
117
views
Loop through an array/range
I want to find in an array/range if one or more cells have red background color. The output ( cell's address + text ) to be returned in a cell outside of range. I don't have any VBA experience and ...
- 21
1
vote
1
answer
51
views
Excel statement that updates only once
I have one cell that indicates the status of a project. And then multiple other columns that are intended to mark the date of when the project changes status.
Status
Date Project New
Date Project ...
- 11
0
votes
0
answers
55
views
Approach to Writing an IF Statement Based on a Column of Values
I am writing a test on REDCAP where the user must enter 5 potential diagnoses based on the data provided. The user will be allowed to enter the answers in any order. When I export, the answers will be ...
- 1
0
votes
1
answer
51
views
If, Then, ElseIf statement solves (using solver) for two of my criteria and returns, but will not solve for the third. No error messages either
I am trying to use VBA to solve for a variable to get three different returns: 10%, 16%, Breakeven. I have to use solver to avoid circular references, but I have 5 different scenarios to solve for all ...
0
votes
1
answer
66
views
Is there a function or way in excel to dynamically take 6 values from ONE cell and compare it with another and return all the matches between the 6? [duplicate]
Let's say COLUMN A cell A1 has values AB111 CD000 EF222 GH333 LM555 RS444
AND lets say COLUMN B1 has some or all the same values in this case 3 matches AB111 OP888 GH333 RS444 ZD999
I am ...
- 11
0
votes
1
answer
54
views
VBA True False Condition [duplicate]
Can someone help me why im getting error, if i do like this in VBA
Worksheets("ME2N").Range("AB6:AB31000").Formula = "=IF(AA6<T6;"False";"True")"
...
