Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF?
Hi,
Hopefully this does what you need: =IF(AND(B3="Stock",C3=1,C3<25),D3*2,0) Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF?
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF?
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=SUMIF | Excel Discussion (Misc queries) | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |