Multiplying two numbers then combining If with And functions including dates

[mmcmillin]

Hello,

I need to see if anyone can help me with multiplying two numbers, then calculating a If plus And function. I'm taking my whole goods sales and multiplying it by my take rate. WG Sales (number) * Take Rate (number) and if my inventory is greater than my max, then I want my total number divided in half. If not, then I want it to stay the same. So if my number is 5, but my inventory max level is 4 then I want to forecast 2.5 units. Here's the catch, I only want this to happen if we're in current month. I want to have the same formula for every month in 2015, but only want the If/And function to take affect in current month. Here's what I have so far. I think I'm close.

$F$39*!J6,IF(AND(AB1<AC4,P6>N6),AB6*0.5,AB6*1)<ac4,p6><ac4,p6><ac4,p6>

I want excel to calculate =$F$39*J6 then if we're in current month and my inventory is above my max then calculate the rest.
<ac4,p6><ac4,p6><ac4,p6>

Thanks!!</ac4,p6></ac4,p6></ac4,p6></ac4,p6></ac4,p6></ac4,p6>

 

[Scott Huish]

Maybe:

=($F$39*J6)*IF(AND(TODAY()<AC4,P6>N6),0.5,1)

 

[mmcmillin]

Maybe:

=($F$39*J6)*IF(AND(TODAY()<AC4,P6>N6),0.5,1)

Thanks!!!! That worked!! I appreciate the help.