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.