If I were to prefill cells with IF statement, that means all other cells (in this case A1 and B1) are blank. How do I add to the IF statement so that if A1 and B1 is not populated, then the IF statement would yeild "0" or stay a blank cell?
Thanks!
If I were to prefill cells with IF statement, that means all other cells (in this case A1 and B1) are blank. How do I add to the IF statement so that if A1 and B1 is not populated, then the IF statement would yeild "0" or stay a blank cell?
Thanks!
Last edited by qvp; 02-24-2012 at 05:29 AM.
TRy
=IF(OR(A1="",B1=""),"",IF(DATEDIF(A1,B1,"m")<=10,"Pink",IF(AND(DATEDIF(A1,B1,"m")>20,DATEDIF(A1,B1,"m")<30),"Dot","Norman")))
begin your if statement with...
if(and(a1="",b1)="",......and then end the formula with...,"")
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
thank you both!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks