Thread
:
formula using several colums
View Single Post
#
11
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
formula using several colums
You DIDN'T say so.!! Always best to fully explain your needs so as to not
waste time of responders. Try this
=MAX(A2-IF(SUMPRODUCT(COUNTIF(INDIRECT({"b1","d1","f1","j1 "}),"sx"))0,100000,50000),0)
--
Don Guillett
SalesAid Software
"jv" wrote in message
...
=MAX(p2-IF(COUNTIF(F2,H2,J2,L2,"sx")0,100000,50000),0)
This is the formula with the true cells listed. I get an error when trying
to use this
"Don Guillett" wrote:
=MAX(A2-IF(COUNTIF(A1:D1,"sx")0,100000,50000),0)
--
Don Guillett
SalesAid Software
"jv" wrote in message
...
The formula would look in colums a b c d and if SX is present them the
formula would subtract $100,000 is result isd a minus it would put zero
in
the cell, If SX is not present the formula would subtract $50,000 and
if
the
result is a minus it would put zero in the cell
A B C D
E
F
HX WR VX SX $100,000 SX HX WR VX $150,000 HX VX SX
$75,000 WR VX HX SX $175,000
HX WR VX $200,000
HX SX VX HX WR VX
HX WX 11
"JE McGimpsey" wrote:
One way:
a) =MAX(A1-200000,0)
b) Not sure what you mean.
In article ,
jv wrote:
I need a formula that would subtract 200,000 from a cell and if the
result is
a minus, zero would be put in the cell.
I also need a formula that check coulme a, b, c, d and if a could
exists it
subtracts an amount from column f
Thanks in advance
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett