Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
"if" statement???
Posted by scott on January 02, 2002 7:20 AM
Any help would be greatly appreciated....
I would like to create a column (ie- "C") in such a way, that when a "Y" is entered, it will multiply ".015" times a the value in column "B", and output the value in column "D". I think I need to put an "If" statement into column "D' that will do this, but am not sure if this is correct, nor what to write. Thanks in advance!
| Check out our Excel Resources
|
 |
 |
use =IF(AND(B10,C1="Y"),B1*0.015,"") in column D and copy down as needed (NT)
Posted by Ian Mac on January 02, 2002 7:34 AM
Or Just =IF(C1="Y",B1*0.015,"") NT
Posted by Scott on January 02, 2002 7:43 AM
if your assuming there is always a number in B?? (NT)
Posted by Ian Mac on January 02, 2002 7:49 AM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.