Forum Discussion
Using IFBLANK with IF Formulas
Yes:
=IF(F1="", "", IF(F1="Standard", ..., IF(F1="Full", ...)))
or
=IFS(F1="", "", F1="Standard", ..., F1="Full", ...)
HansVogelaar Thanks, Hans! I'm no expert, but does that allow for a second conditional formula? What I need to do is create a conditional formula: If A1="Standard", perform this specific calculation but if A1="Full", perform the other specific calculation. Then, I need to wrap all that into an IFBLANK so that if F1 is blank, it does nothing but if F1 has a date value, it performs the above calculations based on the value of A1. Does that make sense?
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!
- Thanks, Hans! I'm stepping out but will try this next and respond here. Thank you!