ExcelBanter - if Then

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if Then (https://www.excelbanter.com/excel-worksheet-functions/220669-if-then.html)

Jamesbfagan

if Then

How would I program the following formula?

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

Teethless mama

if Then

=(A2=1)*B2*8.04

"Jamesbfagan" wrote:

How would I program the following formula?

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

Shane Devenshire[_2_]

if Then

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

All times are GMT +1. The time now is 02:12 AM.