Need help with an IF function
Solved/Closed
AY44
AY44
- Posts
- 3
- Registration date
- Wednesday August 7, 2013
- Status
- Member
- Last seen
- August 7, 2013
AY44
- Posts
- 3
- Registration date
- Wednesday August 7, 2013
- Status
- Member
- Last seen
- August 7, 2013
Related:
- Need help with an IF function
- Functions of spreadsheet - Articles
- Functionality of wifi - Guide
- Function key stuck on - Guide
- Acer function keys not working - Guide
- Mutator functions - Guide
4 replies
good afternoon,
Take a look at your logic, a nested if is still an if. so your logic is written:
=if(logic,true=if(logic,true,false),false)
so, your second logic statement says:
if date is greater than or equal to 1/1/2013 then "Y".
So that is why you are still getting "Y".
Reverse the Y and X in the second statement.
Take a look at your logic, a nested if is still an if. so your logic is written:
=if(logic,true=if(logic,true,false),false)
so, your second logic statement says:
if date is greater than or equal to 1/1/2013 then "Y".
So that is why you are still getting "Y".
Reverse the Y and X in the second statement.
AY44
Aug 7, 2013 at 02:39 PM
- Posts
- 3
- Registration date
- Wednesday August 7, 2013
- Status
- Member
- Last seen
- August 7, 2013
Aug 7, 2013 at 02:39 PM
So, I did as you suggested, changed the formula to:
=IF(AN1="X",IF(D1>=1/1/2013,"X","Y"),AN26)
And instead of getting all of the X's to become Y's, now everything is X. The formula seems to not be looking at the date that is in D1.
Any other help with this one?
=IF(AN1="X",IF(D1>=1/1/2013,"X","Y"),AN26)
And instead of getting all of the X's to become Y's, now everything is X. The formula seems to not be looking at the date that is in D1.
Any other help with this one?
AY44
Aug 7, 2013 at 04:17 PM
- Posts
- 3
- Registration date
- Wednesday August 7, 2013
- Status
- Member
- Last seen
- August 7, 2013
Aug 7, 2013 at 04:17 PM
Now it works! Thank you SOOO MUCH!