"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!

Posted by Ian Mac on January 02, 2002 7:34 AM

use =IF(AND(B10,C1="Y"),B1*0.015,"") in column D and copy down as needed (NT)

Posted by Scott on January 02, 2002 7:43 AM

Or Just =IF(C1="Y",B1*0.015,"") NT

Posted by Ian Mac on January 02, 2002 7:49 AM

if your assuming there is always a number in B?? (NT)