Formula for Telecom calculations? Time/money

  • Thread starter Thread starter GeekBoy
  • Start date Start date
G

GeekBoy

Hello.

I am trying to figure out Excel, and have not used it much.

What I need to do is put in a money amount, lets say $5 and the rate per
minute is $0.025 (2 1/2 cents) a minute.
I need the total minutes available with the total amount of money entered at
the rate listed.

My formulas are all coming out with incorrect results.

Thanks

GB
 
Cell A3 = $5
Cell A4 = $.025 (increase decimals thru format command to show 3 places
else Excel will show .03 even though the cell will store .025

To get minutes available enter the following formula in say D4:
=A3/A4

This will show the total minutes available for $5 at $.025 per minute.
 
Back
Top