Hi,

Although longer, this might help you understand the logic necessary:

In F2

=IF(A2=1,B2*12*.67,"")

You didn't say what to do if there wasn't a 1 in A2?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Jamesbfagan" wrote:

How would I program the following formula?

If A2=1 then F2=B2*12*.67