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...
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...