LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 6
Default Cell phone tariff checker design help

I am producing a mobile phone tariff checker and need some help please.

Column A is dedicated to variable input fields and show minutes used in landline calls peak and off peak, same network calls peak and off peak, cross network calls peak and off peak and voicemail calls. These are fields A5 to A11 respectively. MMS pics and video usage are in A12 and A13. Text message usage is inputed into A14.
The following sum applies to landline calls at peak time only:

=SUM((A5)-(A5/A15)*E3)*E5=IF(U2<0,"0")
where A5 is landline peak time calls in minutes
A15 is total minutes used in one month ie =SUM(A5:A11)
E3 is the tariffs free call allowance to all networks in minutes
E5 is the unit cost to call landlines at peak times in pounds
The IF function is attached because if the monthly usage is far less than the tariff alowance it produces a negative value in pounds
i.e. where A5 is 50, A15 is 250, E3 is 400 and E5 is £0.10 a figure of -£3.00 is produced! Well quite clearly service providers don`t pay us if we don`t use our allocated call allowance! The answer if less than zero should read "£0.00". This entire formula produces zero whether the answer is greater than zero or not.

My main wish is to have the above sum coupled with all the other call possibilities and after that have text message and multi-media messages added to it too.

If we could get started on this i`m sure we will achieve the result. Once it`s finished i can give you all a copy and we will always be on the best tariff to suit our current call usage.

Thanks for your time....

Gareth
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
Phone Dialer Pat Excel Discussion (Misc queries) 5 January 7th 05 06:28 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"