Hi folks,

I have the following problem as seen below, I need to compare column B with column C then return a value in column D based on values in column A. The logic tests are as follows:

Logic test 1: if B2=0 and C2=0 then D2=A3 (0)
Logic test 2: if B2=0 but C2 is an integer then D2=A4 (0,5)
Logic test 3: if C2=0 regardless of column B then D2=A3 (0)
Logic test 4: if B2 is an integer and C2 an integer then D2=A2 (1)

The results are seen in the attached file.logic_tests.xlsx

Can anybody help with a formula that combines these multiple logic tests?

Thank you in advance.