Add IF or Subtract IF??
 

I want to be able to Subtract 'change order'!G34 from 'team pay'!C35 & C36
only if it is a negitave and not to add to it if it is a positive. Not sure
if this is do-able but any help would be appericated.

Ray Byers Jr,
Northern Ca.

Hi
try:
SUM('team pay'!C35:C36)+MIN(0, 'change order'!G34)

--
Regards
Frank Kabel
Frankfurt, Germany

"RJ" schrieb im Newsbeitrag
...
I want to be able to Subtract 'change order'!G34 from 'team pay'!C35
& C36
only if it is a negitave and not to add to it if it is a positive.
Not sure
if this is do-able but any help would be appericated.

Ray Byers Jr,
Northern Ca.

So if i am on the Team pay sheet in Cell C35 how would I write the formula
Thank you all of your help. and I guess I would duplicate it for cell C36.

"Frank Kabel" wrote:

Hi
try:
SUM('team pay'!C35:C36)+MIN(0, 'change order'!G34)

--
Regards
Frank Kabel
Frankfurt, Germany

"RJ" schrieb im Newsbeitrag
...
I want to be able to Subtract 'change order'!G34 from 'team pay'!C35
& C36
only if it is a negitave and not to add to it if it is a positive.
Not sure
if this is do-able but any help would be appericated.

Ray Byers Jr,
Northern Ca.

Hi
not sure what you mean with this. I think you have values in C35 on
this sheet?

--
Regards
Frank Kabel
Frankfurt, Germany

"RJ" schrieb im Newsbeitrag
...
So if i am on the Team pay sheet in Cell C35 how would I write the
formula
Thank you all of your help. and I guess I would duplicate it for cell
C36.

"Frank Kabel" wrote:

Hi
try:
SUM('team pay'!C35:C36)+MIN(0, 'change order'!G34)

--
Regards
Frank Kabel
Frankfurt, Germany

"RJ" schrieb im Newsbeitrag
...
I want to be able to Subtract 'change order'!G34 from 'team
pay'!C35
& C36
only if it is a negitave and not to add to it if it is a
positive.
Not sure
if this is do-able but any help would be appericated.

Ray Byers Jr,
Northern Ca.

Frank I think I found the Answer to my question. You are amazing thank you
for your help and being so quick to answer.

"Frank Kabel" wrote:

Hi
not sure what you mean with this. I think you have values in C35 on
this sheet?

--
Regards
Frank Kabel
Frankfurt, Germany

"RJ" schrieb im Newsbeitrag
...
So if i am on the Team pay sheet in Cell C35 how would I write the
formula
Thank you all of your help. and I guess I would duplicate it for cell
C36.

"Frank Kabel" wrote:

Hi
try:
SUM('team pay'!C35:C36)+MIN(0, 'change order'!G34)

--
Regards
Frank Kabel
Frankfurt, Germany

"RJ" schrieb im Newsbeitrag
...
I want to be able to Subtract 'change order'!G34 from 'team
pay'!C35
& C36
only if it is a negitave and not to add to it if it is a
positive.
Not sure
if this is do-able but any help would be appericated.

Ray Byers Jr,
Northern Ca.