Member Since: 23rd Jan 2005
16th Sep 2011
will produce in the cell in which the formula is entered:
The contents of B12, if B12 is equal to or greater than 0.
"0" if b12 is a negative number.
If instead of just a non-descript "0" you want something more informative, do something like:
Remember to enclose any non-numeric stuff in double inverted commas.
23rd Jan 2008
Am I the most stupid accountant in britain today?
I would charge the £2,500 but advise the client that you are prepared to charge the same amount for the following 1 or 2 years, subject to an exceptional charge in the event of unforeseen circumstances at a specified rate per hour.
That way you should get the best of both worlds. You should have a satisified client who should be happy to budget at least one cost with some certainty, and you have a buffer to offset against any cost inflation.
3rd Jun 2005
I used to be a Sole Practitioner, with a few employees, until a few years ago when I moved on to other things.
When I read comments as in this case, I wonder
how on earth does the smaller accountancy practice survive today with all the attendant bureaucracy?