| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if Then
How would I program the following formula?
If A2=1 then F2=B2*12*.67 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if Then
=(A2=1)*B2*8.04
"Jamesbfagan" wrote: How would I program the following formula? If A2=1 then F2=B2*12*.67 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
