Perform calculation if two other columns contain specific values

Hi there,

It's been a while since I posted a question as i've been learning DAX. But i'm testing some data through excel and my excel learning has gone right out of my head.

So I am creating a pass=1 and fail=0 column.

This is calculated by IF(COLUMNA=>3,1,0)
So column A contains a 0,1,2 it's produces a 1, but three plus is a 0

I also want it to be blank if COLUMNA is blank.

Try something like this, if your data is in A2:

=IF(A2="","",IF(A2>=3,0,1))

Copy down as required.

Hope this helps.

Pete

Thanks Pete! I thought I had trie that and it hadn't worked but I guess I had a wrong parenthesis or something.

Glad it worked for you - thanks for the rep.

Pete