Add IF or Subtract IF??

[Guest]

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 Kabel]

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

 

[Guest]

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]

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

 

[Guest]

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