Now if any of the cell J2, M2, R2, AA2, or AB2 are blank, the formula will return "Not Complete".
#Aa2 mods for abdominals mod
You should be able to modify your formula as follows: =IF(OR(ISBLANK(J2),ISBLANK(M2),ISBLANK(R2),ISBLANK(AA2),ISBLANK(AB2)), "Not Complete", "Complete") Com3d2 mod list It is an offsite patch you have to buy 7 20200306 3D2 MOD CM3D2 COM3D2 MOD Anbsp Custom Maid 3D 2 Kemono Friends MOD Preset Com3d2 mods list Results 1 - 15 of 19 com3d2 mods list 4 Installing ModGet the correct CM3D2 variant of Com3d2 mod list It is an offsite patch you have to buy 7 20200306 3D2. Next, you need to change the ELSE condition of your IF function to return "Complete". So first you need to eliminate those spaces. and so on if required) Extending the SUMIF example above, say we wanted to only summarise the data by builder, for jobs in the central region. This might seem insignificant, but Excel can be very picky and will return a #NAME? error. The function wizard in Excel describes the SUMIFs Function as: SUMIFS ( sumrange, criterarange1, criteria1, criteriarange2, criteria2. =IF(OR(ISBLANK(J2),ISBLANK(M2),ISBLANK(R2),ISBLANK (AA2),ISBLANK (AB2)),"Not Complete","")Īnswer:First, you are correct in using the ISBLANK function, however, you have a space between ISBLANK and (AA2), as well as ISBLANK and (AB2). This is what I have so far and it doesn't work. Question:I am trying to get Excel to check different boxes and check if there is text/numbers listed in the cells and then spit out "Complete" if all 5 Boxes have text/Numbers or "Not Complete" if one or more is empty.