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
 Excel grade formula  Guide
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Excel free download  Download  Spreadsheets
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.