# Calculated Column with Multiple Queries

This may seem really basic but I'm struggling to get my head around it. I have 2 boolean columns (Checked by TL and Checked by CSS), I need a calculated column to give me one of three results;

1: Checked by Both - this is where both of the columns are True

2: Checked by CSS - this is where the Checked by CSS column is True and the Checked by TL column is False

3: Checked by TL - this is where the Checked by TL column is True and the Checked by CSS column is False

I may have used the right formula in my testing but kept getting a syntax error which I couldn't fix by bracket counting so I'd appreciate any help with this one

Solved;

``````=IF(AND([Checked by CSS]=TRUE,[Checked by TL]=TRUE),"Checked by Both",IF(AND([Checked by CSS]=FALSE,[Checked by TL]=TRUE),"Checked by TL",IF(AND([Checked by CSS]=FALSE,[Checked by TL]=FALSE),"Unchecked",IF(AND([Checked by CSS]=TRUE,[Checked by TL]=FALSE),"Checked by CSS"))))
``````

``````=IF(AND([Checked by CSS]=TRUE,[Checked by TL]=TRUE),"Checked by Both",IF(AND([Checked by CSS]=TRUE,[Checked by TL]=FALSE),"Checked by CSS",IF(AND([Checked by CSS]=FALSE,[Checked by TL]=FALSE),"Unchecked",IF(AND([Checked by CSS]=FALSE,[Checked by TL]=TRUE),"Checked by TL"))))
1. Sometimes comma(`,`) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(`;`) instead of comma(`,`).