Forum Discussion

Stymied9's avatar
Stymied9
Frequent Visitor
9 years ago
Solved

IF / AND / OR statements

This is the Excel version of the formula I am using which is not working: =IF(OR(V3>19958*0.85,AND(Y3="20FT_COFC",AF3>33*0.85),AND(Y3="40FT_COFC",AF3>67*0.85),AND(Y3="40FT_HC",AF3>76*0.85)),"","Not ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Would something like this work?

    ResultColumn = IF(
	[Total Master Wgt] > (19958 * 0.85),
	"Optimized",
	SWITCH(
		[Equipment Type],
		"20FT_COFC", IF([CBM] > (33 * 0.85), "Optimized", "Not Optimized"),
		"40FT_COFC", IF([CBM] > (67 * 0.85), "Optimized", "Not Optimized"),
		"40FT_HC", IF([CBM] > (76 * 0.85), "Optimized", "Not Optimized"),
		"Not Optimized"
	)
)


    You'll need to check your field names, i've done this based on your screenshot.

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Would something like this work?

ResultColumn = IF(
	[Total Master Wgt] > (19958 * 0.85),
	"Optimized",
	SWITCH(
		[Equipment Type],
		"20FT_COFC", IF([CBM] > (33 * 0.85), "Optimized", "Not Optimized"),
		"40FT_COFC", IF([CBM] > (67 * 0.85), "Optimized", "Not Optimized"),
		"40FT_HC", IF([CBM] > (76 * 0.85), "Optimized", "Not Optimized"),
		"Not Optimized"
	)
)


You'll need to check your field names, i've done this based on your screenshot.

 

  • Stymied9's avatar
    Stymied9
    Frequent Visitor
    9 years ago

    That DID work Ross !  Thank you very much!