Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there any way around the maximum of seven nested functions? | Excel Worksheet Functions | |||
limit of 7 nested functions? | Excel Worksheet Functions | |||
Limited IF Nested Level functions. | Excel Discussion (Misc queries) | |||
how do I use multiple nested functions? | Excel Worksheet Functions | |||
ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS | Excel Worksheet Functions |