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
refe
On Sun, Aug 7, 2011 at 16:00, Gene Kohlenberg 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
>> seas
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 constant