SUMIF?

T

tss

Need help building a formula, what I need to accomplish is this:
Formula in CELL A
IF CELL B = "Stock" and CELL C >=1, <25 Than CELL D *2
Not sure how to build this.
 
T

tss

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.
 
S

Simon Lloyd

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

tss;610483 said:
Chris
Thanks, I did not explain what I wanted to do very well, You got m
ver
close, what I finally wanted to get, was IF B3 was Stock, and C3 wa
Than Multiply D3 by 2

A B C
Stock $11.14 1.00 A should be

Hopefully this is explained better
Click to expand...

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
S

Simon Lloyd

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

tss;610483 said:
Chris
Thanks, I did not explain what I wanted to do very well, You got m
ver
close, what I finally wanted to get, was IF B3 was Stock, and C3 wa
Than Multiply D3 by 2

A B C
Stock $11.14 1.00 A should be

Hopefully this is explained better
Click to expand...

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
Top