Thought I'd say hi to you all

[Atomic Mitten]

Hi all,

just stopped by to say hi to my old buddies.

[Mahdi]

Hey Atomic!

Remember back in June when you said you were back on a regular basis and then never posted again? ;)

[Andrew]

I remember that as well Mahdi, Hi all, how you all doing ?

Welcome back again!

[Chani]

hello, :)

[erjin999]

Stop poppping in and saying hello and come back and get posting dude. You can also start playing when you have more time, as it seems you must be kinda busy !  :-

[Kiyouta]

I remember that as well Mahdi, Hi all, how you all doing ?

Welcome back again!

Oh yeah I remember that... you ever get that Excel thing sorted Andrew? ;)

Doubt KaL managed to tie his shoelaces... :(

[Andrew]

Most of my excel problems were solved, except one.

It is under the status column.

I have =IF(N$5>SUM(E$5:E5),"Paid","") to tell whether a person has paid enough to cover the cost.

Now if I have =IF(N$5>=SUM(E$5:E5),"Paid","") instead, this works, but the status of paid goes all the way down until the forumula ends (doesnt look good, but I can simply not print that part off.

What I am trying to get is an accurate view of whether a person has paid for the cut or not. Is it possible to have a 2/3 paid etc? Maybe they have only partially paid for the lawn.

I don't use the "status" column for any calculating, so it is not that important, other than making it easier for me to print it off and give to a client they know exactly what the status means (accuracy).

That's the only problem I can think of right now. Although I have added tremendous amount of data/formulas to the spreadsheet since then.

EDIT - I could actually use the "paid" in certain formulas, although would be nice if it was somehow more accurate. ie number of cuts paid / total cuts

[attachment archived by Gobalopper]