what I need to calculate is, if H2 is less than 1.5, and M2 is 1 then return value of 1, or if M2 is 0, then return 0,

I need to get this working for H2 values lover then 1.5, between 1.5 and 1.9, and more than 2.

If I get those values (0/1) returned I can calculate percentages easily.

any suggestions?

all help will be appreciated