Excel formula that multiplies the value of a cell times 2 only if it is under $.99?

Question

Hello and thank you for your help! I am writing a formula to help me calculate coupon deals for my shopping trip. My store doubles coupons $.99 or under, so I need a formula that does the following: If the value in cell D2 is less than $1.00, multiply the value by 2 and spit it out in D3. I tried writing my own formula but it is not working, obviously :( =PRODUCT(IF(D2

Answer 1

Try this for your D3 evaluated column

=D2*(IF(D2<1,2,1))