Needing help with an IF, AND, ISBLANK and NOT(ISBLANK) statement.
I'm trying to write IF K5 is not blank and K8 is blank then K9 would be blank.
Is this possible?
Needing help with an IF, AND, ISBLANK and NOT(ISBLANK) statement.
I'm trying to write IF K5 is not blank and K8 is blank then K9 would be blank.
Is this possible?
Last edited by ExcelDummy77; 07-16-2015 at 02:06 PM.
Perhaps this...
=if(and(K5<>"",K8=""),"","you-didnt-say-what-you-want-here")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
HA! I didn't need a false return on this formula because I've got it nested in a few other IF statements.
Appreciate the help! That worked!
Thanks!
Awesome, happy to help and thanks for the feedback (you just gave me my 7 000'th rep point)
Probably be better if you start a new thread on that
thanks. will do!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks