Chris,
Thanks, I did not explain what I wanted to do very well, You got me very
close, what I finally wanted to get, was IF B3 was Stock, and C3 was =1, <25
Than Multiply D3 by 2,

A B C D
Stock $11.14 1.00 A should be 2

Hopefully this is explained better.

"Chris" wrote:

Hi,

Hopefully this does what you need:

=IF(AND(B3="Stock",C3=1,C3<25),D3*2,0)

Chris
.