EXCEL FORMULA
Solved/Closed
Egogym
Posts
1
Registration date
Monday May 15, 2017
Status
Member
Last seen
May 15, 2017

May 15, 2017 at 08:42 PM
Blocked Profile  May 16, 2017 at 04:58 PM
Blocked Profile  May 16, 2017 at 04:58 PM
Related:
 EXCEL FORMULA
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Excel marksheet formula  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Transfer data from one excel worksheet to another automatically formula  Guide
1 response
Ok lets break it down:
=IF(F4="DIA",E4*30,IF(AND(F4="MES",G4="CLASES")=E4/30*300,IF(AND(F4="MES",G4="APARATOS")=E4/30*400,IF(F4="SEMANA",E4/7*100,IF(AND(F4="AÑO",G4="APARATOS"),E4/365*4400,IF(AND(F4="AÑO",G4="CLASES"),E4/365*3300,""))))))
IF(AND(F4="MES",G4="CLASES")=E4/30*300 is a false value only as MES cannot equal E/30*300! Any comparisons that are formulated in this manner are false, so you will never have a true, except the first one,becaue it is possible to have cell F4="DIA". It is not possible for MES to equal e4/30*300.
=IF(F4="DIA",E4*30,IF(AND(F4="MES",G4="CLASES")=E4/30*300,IF(AND(F4="MES",G4="APARATOS")=E4/30*400,IF(F4="SEMANA",E4/7*100,IF(AND(F4="AÑO",G4="APARATOS"),E4/365*4400,IF(AND(F4="AÑO",G4="CLASES"),E4/365*3300,""))))))
IF(AND(F4="MES",G4="CLASES")=E4/30*300 is a false value only as MES cannot equal E/30*300! Any comparisons that are formulated in this manner are false, so you will never have a true, except the first one,becaue it is possible to have cell F4="DIA". It is not possible for MES to equal e4/30*300.