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<"$1.00")D2 * 2) Any ideas?

Answer 1

To make it easier to audit you can also name cell D2 and call it CouponValue (no spaces in the range name). Then you can use that reference in the formula. To name the cell, you select it and type the name you want into the Name Box at the intersection of columns and rows in the top left.

The formulas above are notated first with the cell value (D2) and second with the cell name (CouponValue). Otherwise, they are identical.

This is how it calculates when the CouponValue is higher than $.99.

Answer 2

Suppose the cell is b3 The size of your coupon next to it us the if command =IF(B3<=.99,2*B3,B3) this will give you a double coupon if it is less than 99 cents.