Need to know if a cell is blank if a certain condition is met.

[Jowel]

Hi
It feels like this should be really simple to do but i dont know how.
If i have a condition that is met in column a, column c should be multiplied with column d.
Some time d is blank and that is what i need a formula to tell me. If the condition in column a is met but the cell in d is blank.

I got a big spreadsheet, so i attached an exampel. The exampel is just an exampel but it based on the same principle.

I appreciate any help I can get.

[NeedForExcel]

Hey!

Put this is Cell F3 and Drag Down

=IF(AND(A3="C",D3=""),"Condition Met","Condition Not Met")

Deep

[NeedForExcel]

And Forgot to mention, change the "Condition Met","Condition Not Met" to what ever you want..

[Jowel]

Thanks for the answear but i realize i made a small misstake when i made the exampel file.
I need it to be in one cell, because i will have a few different conditions, each on a new row, and cant do any help column.
And it isnt the same columns for everyone so i cant just look for blanks in a certain column, because almost all columns should have a majority blank cell.
I dont know if this made it any clearer what i need?

[NeedForExcel]

Actually, I dont quite understand what you are trying to explain..

[Jowel]

I canīt use a help column.
In the real spreadsheet there is loads of data that varies and that will be copy pasted in. This formula will be in another sheet with other formulas around it checking/controlling other things from the data. So i need this to be done in 1 cell, where it present if we need to do something with the indata or if it is correct.
did that make it any more understandable?

[Dreambringer]

There are a few things I am little confused about, first, where do you want the formula to be? Do you want just the first blank cell? or all cells?

After looking at your worksheet, would conditional formatting work for you? I would us something like:

Please Login or Register  to view this content.

Where 'a' would be the condition that needed to be met!

Check this out, and let me know when it works for you!

[Jowel]

I am making a new exampel spread sheet. posting it as soon as i can.
Dreambringer, no.

[Jowel]

Lets see if this makes it easier to understand what I need. It is under result in the check column I need this formula.

Might add i am not allowed to use VBA

And this is still a simplicifaction of it, with alot more calculations happening, but i got a column with a row for each criteria i need to check.

[Dreambringer]

So if we are to understand you correctly, In G4, IF A4 = C AND D4 = 0 THEN you want to display a TRUE/FALSE value?

[Jowel]

Yes thats correct, with the exception that if any cell in A = C and got a blank or zero in D i want to display true or false.

Edit: Noticed that I actually have the problem also on row 15 and 26 aswell, not only on row 4 in the data column. I only need the formula to tell me there is a problem i do not need it to say anything about how many places or where.

[NeedForExcel]

Here!

Put this in G4.

=AND(A4="C",D4=0)

Cheers!

Deep

[Jowel]

The problem with that formula is that it requiers that I know where I have the problem. What i want to know is wether or not there is any where a C in the A column with a blank cell in the D column.

[Jowel]

Solved it by using:
=IF((SUMIFS(Data!C:C;Data!A:A;"c";Data!D:D;""))>0;"Bad";"Ok")