JP2R
03-06-2008, 08:47 PM
Greetings all -
I hope that I post this correctly - this is my first post to the group. I've read the rules, and believe I understood.
I have an image to help explain what it is that I'm trying to attempt...(I hope it's attached)
I tried to write this as an "IF" statement, but believe it is not possible to write an IF where it states "Is Not Null" in a function, but requires a VBA.
I'm trying to write something that provides an answer to the following question(s).
If Column "AB" and "AC" are Empty and Column "AD" is less than "Y" - then Column "AG" is Empty.
If Column "AB" and "AC" are Empty and Column "AD" is greater than "Y" - then Column "AG" is 1.
If Column "AB" and "AC" are Not Null and Column "AD" is greater than "Y" - then Column "AG" is Empty.
Now as I see this I wonder if it should not be a Case Statement Instead.
I'm new to VBA and the more advanced functions - so I apologize in advance if I've missed something...
I'm using Windows XP
Excel 2007
-- Monk
I hope that I post this correctly - this is my first post to the group. I've read the rules, and believe I understood.
I have an image to help explain what it is that I'm trying to attempt...(I hope it's attached)
I tried to write this as an "IF" statement, but believe it is not possible to write an IF where it states "Is Not Null" in a function, but requires a VBA.
I'm trying to write something that provides an answer to the following question(s).
If Column "AB" and "AC" are Empty and Column "AD" is less than "Y" - then Column "AG" is Empty.
If Column "AB" and "AC" are Empty and Column "AD" is greater than "Y" - then Column "AG" is 1.
If Column "AB" and "AC" are Not Null and Column "AD" is greater than "Y" - then Column "AG" is Empty.
Now as I see this I wonder if it should not be a Case Statement Instead.
I'm new to VBA and the more advanced functions - so I apologize in advance if I've missed something...
I'm using Windows XP
Excel 2007
-- Monk