G
Gareth Trow
Hi Fred,
Thanks for your reply. The formula shown in this page
=IF(U20,0,0,SUM((A5)-(A5/A15)E3)*E5) is different to the one given in
my outlook express message which was:
=IF(U2<0,0,SUM((A5)-(A5/A15)E3)*E5)
After trying both the outlook formula worked.
However, when this formula was used on another lower priced tariff it
still gave a zero figure when a chargeable amount should have been
given. The formula checker shows the correct amount but shown in the
cell is £0.00.
Below are two examples with the different cell amounts and their
units.
Scenario 1:
=IF(C16<0,0,SUM((A5)-(A5/A15)C3)*C5)
C16 is the formula cell only
A5 is the input cell and is 50 minutes of talk time used to land lines
peaktime,
A15 is 250 minutes of total talk time used for all types of calls,
C3 is the tariff call allowance of 200 minutes
C5 is £0.10 the call cost for land lines at peak time per minute
This should give an answer of £1.00 (but shows £0.00)
Scenario 2:
=IF(E16<0,0,SUM((A5)-(A5/A15)E3)*E5)
E16 is the formula cell only
A5 is the input cell and is 50 minutes of talk time used to land lines
peaktime,
A15 is 250 minutes of total talk time used for all types of calls,
E3 is the tariff call allowance of 400 minutes
E5 is £0.10 the call cost for land lines at peak time per minute
This should give an answer of £0.00 (and does)
Circular reference keeps flagging up but when i check the formula with
the logical test it gives the correct answer everytime. When i close
the formula check box £0.00 is shown in the cell regardless of whether
the value is higher than zero or not. Very confusing and totally beyond
my knowledge. Any further help would be greatly appreciated.
Best Regards
Gareth...
Thanks for your reply. The formula shown in this page
=IF(U20,0,0,SUM((A5)-(A5/A15)E3)*E5) is different to the one given in
my outlook express message which was:
=IF(U2<0,0,SUM((A5)-(A5/A15)E3)*E5)
After trying both the outlook formula worked.
However, when this formula was used on another lower priced tariff it
still gave a zero figure when a chargeable amount should have been
given. The formula checker shows the correct amount but shown in the
cell is £0.00.
Below are two examples with the different cell amounts and their
units.
Scenario 1:
=IF(C16<0,0,SUM((A5)-(A5/A15)C3)*C5)
C16 is the formula cell only
A5 is the input cell and is 50 minutes of talk time used to land lines
peaktime,
A15 is 250 minutes of total talk time used for all types of calls,
C3 is the tariff call allowance of 200 minutes
C5 is £0.10 the call cost for land lines at peak time per minute
This should give an answer of £1.00 (but shows £0.00)
Scenario 2:
=IF(E16<0,0,SUM((A5)-(A5/A15)E3)*E5)
E16 is the formula cell only
A5 is the input cell and is 50 minutes of talk time used to land lines
peaktime,
A15 is 250 minutes of total talk time used for all types of calls,
E3 is the tariff call allowance of 400 minutes
E5 is £0.10 the call cost for land lines at peak time per minute
This should give an answer of £0.00 (and does)
Circular reference keeps flagging up but when i check the formula with
the logical test it gives the correct answer everytime. When i close
the formula check box £0.00 is shown in the cell regardless of whether
the value is higher than zero or not. Very confusing and totally beyond
my knowledge. Any further help would be greatly appreciated.
Best Regards
Gareth...