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 grade 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.
