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
