On Sun, Aug 7, 2011 at 16:00, Gene Kohlenberg <[email protected]> wrote: > On 8/7/2011 4:33 PM, Wade Smart wrote: >> >> 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 >> > Are you wanting row three to be =IF(b3=125,b3-ay2,'')? If so, then set row > two to =IF(b2=125,b2-ay$2,''), then copy and paste into the following rows. > > -- > ----------------------------------------------------------------- > To unsubscribe send email to [email protected] > For additional commands send email to [email protected] > with Subject: help >
AH, that worked great, thanks :D 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
