Hi Wade, Make the references to the fees absolute by adding a $ before them:
=IF(b2=125,b2-$ay$2,'') Column and row are absolute =IF(b2=125,b2-ay$2,'') Row is absolute =IF(b2=125,b2-$ay2,'') Column is absolute When you copy the formula, the absolute parts stay the same, non-absolute references will increment. tc >________________________________ >From: Wade Smart <[email protected]> >To: [email protected] >Sent: Sunday, August 7, 2011 4:33:56 PM >Subject: [users] subtracting rows from a constant number > >Im working on another form for the soccer leage. > >I have a row like this: > >Payment First Last etc //// > >This is the player information, if they registered for the year or >season and how much they paid. > >Out on column AW I have the start of some constants. >Field Fee year >Field Fee season >Ref fee >reg fee >etc. > >So what I want to do is: > >Registration Payment - (the fees(based on if its a yearly payment or >seasonal payment)) > >which I can do but, what I cant seem to figure out is, >when I start on the next row, how can I tell row three to look at the >same constants? > >So: =IF(b2=125,b2-ay2,'') > >On line this what happens is >=if(b3=125,b3-ay3,"") >which throws an error because I just have those numbers in aw2-ba2. > >How can I do the rest of the lines without populating all those field >unnecessarily? > >Wade > >-- >--- >Registered Linux User: #480675 >Linux since June 2005 >-- >----------------------------------------------------------------- >To unsubscribe send email to [email protected] >For additional commands send email to [email protected] >with Subject: help > > >-- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
