Need a little excel Help

I_M_Weasel · 18 Mar 2010 at 14:07

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?

MowyTone · 18 Mar 2010 at 14:11

I dont know the excel way of doing it but i would say it is possible. something like

Code:

 if b1 > b2 then b3 = (b1 - b2)

something like that maybe?

fretted · 18 Mar 2010 at 14:45

Whats the difference between "Total number fines paid" and "number of fines paid"?

The formula, to be placed in the cell(s) where you want the result to show, would look like this:

=if(b2-a2>0,"owes fines", "")

I_M_Weasel · 18 Mar 2010 at 14:52

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.

Manlove is my forte · 18 Mar 2010 at 14:52

edit beaten

I_M_Weasel · 18 Mar 2010 at 15:31

Thanks for that fretted, it did just what I needed.