too many nested IF functions
I have created the below IF formula but it will not let me go any further.
=IF(D3="Especial",(((H3-0.12)*1.4)+0.3),IF(D3="Nacional",(((H3-0.12)*1.4)+0.3),IF(D3="Llam.
Interna",(((H3-0.12)*1.4)+0.3),IF(D3="Internacional",(((H3-0.3)*1.4)+0.3),IF(D3="Núm.
Vodafone",(((H3-0.12)*1.4)+3),IF(D3="Mensaje
Corto",(H3*104),IF(D3="Realiz.Vodafone World",(H3*1.4),IF(D3="Recib.
Extranj",(H3*1.4)))))))))
I still need to add in:
IF(D3="Provincial",(((H3-0.12)*1.4)+0.3),IF(D3="Sms
enviado.roaming",(H3*1.4), IF(D3="Realiz.Roaming",(H3*1.4),IF(D3="Sms
extranj-España",(H3*1.4),
and maybe a couple more
Please can somebody help?
Many thanks
Mand
|