Date based If Statement

Hi all,

Simply I'm trying to get one cell to multiply by a certain number, and then another by a certain number, to which they are both added together.

However, depending on the date of another cell, the value of which they are multiplied changes.


If the date value of H2 falls between 1/11/yyyy, then E2 is multiplied by 185, if it doesn't fall between the two dates, its multiplied by 220

ADD

If the date value of H2 falls between 1/11/yyyy, then F2 is multiplied by 185, if it doesn't fall between the two dates, its multiplied by 220

END PRODUCT



The formula below is what I already have:

(if(h2=datevalue(1/11/yyyy:31/2/yyyy),e2*185,e2*220))+(if(h2=datevalue(1/1/yyyy:31/3/yyyy),f2*30,f2*35))




Any ideas appreciated!

Thanks,

WWM