I have an Excel spreadsheet that I run for our condo that lists the suite
numbers and the key numbers. The owners pay $12.00 for each key up to a
maximum of 4. Beyond that, they are charged $50.00. When an owner comes along
for another key, I would like the program to show quickly whether they owe
$12.00 or $50.00. They could come months later so there is no sequence as to
how many key they have except to labouriously check the list and count the
number of entries for their particular suite. I can do a sort by suite which
would show it up but I am wondering if there is a conditional formula that
can be used: i.e. IF(€¦THEN€¦) or something else.

Any help will be greatly appreciated.

Norm.