This should be what you need:
=IF(AND(B2="Stock",C3=1,C3<25),D3*2,"Criteria not met")

tss;610483 Wrote:
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
.



--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=169490

Microsoft Office Help