Forum Discussion
Using IFBLANK with IF Formulas
Yes:
=IF(F1="", "", IF(F1="Standard", ..., IF(F1="Full", ...)))
or
=IFS(F1="", "", F1="Standard", ..., F1="Full", ...)
Hans, that was it! Took a couple passes to get the syntax correct but it worked. Thanks for your help! Turns out it created a COUNTIF problem when I added the new category ("Full") but I'm trying to work that out using the same logic. 🙄 No luck so far. Can I post back here if I have trouble with COUNTIF or should I start a new thread? HansVogelaar
Feel free to post a reply in this discussion.
- Hans, I'm stumped. I have a cell with an ISBLANK function. The True result is "", the false result is a COUNTIF formula. Here's the formula I'm trying to build - I need to count the cells where:
- The cell in the C column = "Standard" (I have a drop down, 2 options)
- The Dates in columns G-O are within a date range specified in Q, R, & S.
I can do one or the other, but when I try to put them together, it breaks and I get #VALUE! Here's what I'm using now:
=IF(AND(ISBLANK($G$18:$G$517),ISBLANK($J$18:$J$517),ISBLANK($M$18:$M$517))," ",COUNTIFS(C18:C517,"=Standard",$G$18:$O$517,">="&DATE($Q$6,$R$6,$S$6),$G$18:$O$517,"<="&DATE($Q$7,$R$7,$S$7)))
If I take out the date portion, it counts Cells with "Standard" accurately. If I take out the Standard portion, it counts the dates in the cell range accurately. I just can't seem to do both and I'm guessing it's a syntax issue. Any thoughts? Thanks in advance!Could you attach a small sample workbook without sensitive data? That would allow me to experiment.
Thanks in advance.
HansVogelaar Thanks, Hans. Let me know if this opens for you. The cells I'm trying to fix are S9, S10, S11, and V9, V10, V11. Thank you again for your help!