Need a little excel Help

Associate
Joined
10 Sep 2008
Posts
1,656
Is this possible in excel and if so how do i do it.

I have 3 columns,

1, Number of fines
2, number of fines paid
3, Total fines paid

I'd like to have a 4th column that would say something like "owes fines", I imagine there is some way of doing this by comparing column 2 against one, if 1 is greater than 2 that would equal "owes fines".

Can it be done?
 
the difference is "Total fines paid" is referring to the cash amount paid "number of fines" is how many times this person has commited an offence thats earned them a fine, its almost redundant in reality except for a few strange circumstances.

Thanks for the reply I'll give that a try.
 
Back
Top Bottom