Cellphone tariff checker

G

Gareth Trow

Hi Jon,

C16 and E16 are the totals boxes for the tariff in Column C and
respectively.

You are 100% correct re what you have stated too.
What is required is:
For example If E16 is less than zero (in this case it is -£3.00) the
£0.00 should be displayed. The problem is what is displayed in C16. Th
logical test answer is £1.00, which is correct but when ENTER is presse
C16 displays £0.00 too. No matter what the value of A15 it always read
£0.00 in C16.
I am using Excel 2000 at work. Would any conflict arise with 2003`s wa
of inputting formulae?

Best Regards

Gareth...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top