Multiple logic test question

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.

Try this:

=IF(C2=0,$A$3,IF(B2>0,$A$2,$A$4))

Minnesotaart formula worked perfectly, thanks.

I also changed rugulduy formula to this =IF(C2=0;$A$3;IF(AND(B2=0;C2=INT(C2));$A$4;$A$2)) and it also worked.

Thanks a lot for your generous help.