-
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.
if scenarios formula
-
Nested Ifs Based on the Calendar Year
I have been trying to have a nested IF statement based on the year. It seems like the year portion is causing the issue but I cannot seem how to fix this, I am trying to have multiple years on the same sheet but have a formula to pull up by the year I select. SAMPLE FORMULA: IF(A1="2019"...- tycasey17
- Thread
- formula if scenarios formula nested nested "if statements" year
- Replies: 4
- Forum: Excel Questions
-
H
If Statement
Need help with if statements. See attached for the spreadsheet. <colgroup><col><col><col><col><col span="2"><col></colgroup><tbody> What I am trying to do all within Column G is; 1) IF Column F is empty take date from Column E - see formula above 2) If column B says "No", column G...- helpme290
- Thread
- column date days if scenarios formula statements
- Replies: 5
- Forum: Excel Questions
-
R
If function for positive and negative numbers
Hello, I am trying to make a formula to look at the previous column, if it's a positive number it is to do one scenario, and if it's negative it needs to carry out another formula. So in words - If A1 is less than 0, then answer is B1, if A1 is more than 0 then answer is (B1+(D1-C1)) Hope...- reesjonesrb
- Thread
- if scenarios formula
- Replies: 4
- Forum: Excel Questions
