BANCO AMIGO
SALDO INICIAL. =I9
MENSAJE. =SI(E9 = 1,"Deposito", SI(E9=2,"Retiro", SI(E9=3,"Devolucion","Error")))
COMISION. =SI(E9=3,G9*20%,"")
SALDO ACTUAL. =SI(E9=1,D9+G9,SI(E9=2,D9-G9,SI(E9=3,D9-H9,"Error"))
MENSAJE. =SI(E9 = 1,"Deposito", SI(E9=2,"Retiro", SI(E9=3,"Devolucion","Error")))
COMISION. =SI(E9=3,G9*20%,"")
SALDO ACTUAL. =SI(E9=1,D9+G9,SI(E9=2,D9-G9,SI(E9=3,D9-H9,"Error"))
Comentarios
Publicar un comentario