EXCEL FORMULA

[Solved/Closed]
Report
Posts
1
Registration date
Monday May 15, 2017
Status
Member
Last seen
May 15, 2017
-
 Blocked Profile -
HI,
I HAVE THIS FORMULA
=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,""))))))

WHICH WORKS FOR THE "DIAS'' CELLS ONLY, BUT WHEN IT COMES TO THE OTHER CELLS, IT APPEARS A FALSE ERROR.

HOW CAN I FIX IT?

1 reply


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.