Multipe If Statements

[everyday_m]

So What I need in Y is if W is over .1400 to say HA, if W is between .1150 and .1399 to say H, if W is 0 and X is greater then .045 to read G, and not to put nothing or NA if none of the conditions are met.

Thank You In advance.

 

[kweaver]

Welcome to Mr. Excel,

You don't have very many examples, but maybe this will work in Y2 and filled down:

=IF(W2>0.14,"HA",IF(AND(W2>0.115,W2<0.1399),"H",IF(AND(W2=0,X2>0.045),"G","NA")))

 

[everyday_m]

=IF(W2>0.14,"HA",IF(AND(W2>0.115,W2<0.1399),"H",IF(AND(W2=0,X2>0.045),"G","NA")))

Bingo that worked.... thank you