EXCEL FORMULA [Solved/Closed]

Egogym 1 Posts Monday May 15, 2017Registration date May 15, 2017 Last seen - May 15, 2017 at 08:42 PM - Latest reply: ac3mark 9571 Posts Monday June 3, 2013Registration dateModeratorStatus June 19, 2018 Last seen
- May 16, 2017 at 04:58 PM
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?
See more 

1 reply

ac3mark 9571 Posts Monday June 3, 2013Registration dateModeratorStatus June 19, 2018 Last seen - May 16, 2017 at 04:58 PM
0
Thank you
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.