need help with formula calls per minute

**normandaniel09** · 03-24-2013, 11:16 PM

Hello all, can someone please help me do the formula for these, im new to excel thanks guys....

Create a new column called bill.

For all calls starting with 4 (ie mobiles) create a formula to charge then $0.17 per minute based on their call time.

For all other calls (local and std) charge is $0.1.

**icestationzbra** · 03-24-2013, 11:49 PM

if cell A1 has the phone number and cell B1 has the minutes data, then you could use something like this in cell C1:

=if((--left(a1))=4,0.17*b1,0.10*b1)

**normandaniel09** · 03-25-2013, 03:36 AM

Hi sir icestationzbra, tnx for the reply, here is a sample... local is charged to $0.1 per minute and mobile number is charged to $0.17$ per minute.

phone_number length_in_sec charged call
(local) 297859550 37
(mobile) 414419498 178

Regards,
Norman

**normandaniel09** · 03-26-2013, 02:37 AM

one more thing sir icestationzbra, can i do these for all the columns so I will not do it one by one??? If so can you please show me the steps ... thanks u so much sir..

Regards,
Norman