b'Si NP =2 Entonces Tarifa3.00 De lo contrario Tarifa2.15 Caso P Si NP =2 Entonces Tarifa1.70 De lo contrario Tarifa1.20 Caso N Si NP =2 Entonces Tarifa1.20 De lo contrario Tarifa0.85 Fin de Segn NTramosCociente(Kms/5) Si Residuo(Kms/5)0 Entonces NTramosNTramos+1 MontoACobrarNTramos * Tarifa * NP Escribir Monto a cobrar =, MontoACobrar FINSolucin: Option Explicit Private Sub cbCalcular_Click() Dim Tipo As String Dim NP As Byte Dim Kms As Integer Dim Tarifa As Single Dim NTramos As Integer Dim MontoACobrar As SingleTipo = Range("B3") NP = Val(Range("B4")) Kms = Val(Range("B5"))Select case Tipo Case D If (NP = 2) Then Tarifa = 3.00 Else Tarifa = 2.15 Case P If (NP = 2) Then Tarifa = 1.70 Else Tarifa = 1.20 Case N If (NP = 2) Then Tarifa = 1.20 Else Tarifa = 0.85 Autor: Jos M. Martn Senmache S.Pgina 445'