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

Blocked Profile
May 16, 2017 at 04:58 PM
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.
0