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

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

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

I can't tell with your linewrap what you're subtracting 50,000 or
100,000 from.

Assuming it's the values in A:D (e.g., SUM(A1:D1) for row 1), one way:


=MAX(SUM(A1:D1)-50000*(1+(COUNTIF(A1:D1,"*SX*")0)),0)

In article ,
jv wrote:

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

In columns a1:d1the formula would be looking for a code SX If present the
formula would subtract $100,000 from colume E1 and if the result is a
negative it woud put a zero. If SX is NOT present in A1:D1 then the formula
would subtract $50,000 from E1 and if the result is a negative put a zero in
the cell

"JE McGimpsey" wrote:

I can't tell with your linewrap what you're subtracting 50,000 or
100,000 from.

Assuming it's the values in A:D (e.g., SUM(A1:D1) for row 1), one way:


=MAX(SUM(A1:D1)-50000*(1+(COUNTIF(A1:D1,"*SX*")0)),0)

In article ,
jv wrote:

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

Then replace the SUM(A1:D1) in the formula I suggested with E1

In article ,
jv wrote:

In columns a1:d1the formula would be looking for a code SX If present the
formula would subtract $100,000 from colume E1 and if the result is a
negative it woud put a zero. If SX is NOT present in A1:D1 then the formula
would subtract $50,000 from E1 and if the result is a negative put a zero in
the cell

"JE McGimpsey" wrote:

I can't tell with your linewrap what you're subtracting 50,000 or
100,000 from.

Assuming it's the values in A:D (e.g., SUM(A1:D1) for row 1), one way:


=MAX(SUM(A1:D1)-50000*(1+(COUNTIF(A1:D1,"*SX*")0)),0)

In article ,
jv wrote:

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

=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

=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

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

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

One way ..

Try in say, B2: =MAX(A2-200000,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Homework??

=MAX(G11-200000,0)
for the second one explore using MATCH or LOOKUP

--
Don Guillett
SalesAid Software

"jv" wrote in message
...
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