Inpute=B1, Formula=B2, Formula=B3 I want in B2 , B1>8 but <10 = value

in B3 , B1>10 = value

Since you didn't say what you want returned if the specified criteria isn't met, I assumed a blank cell. For B2:

=IF(AND(B1>8,B1<10),"value","")

For B3:

=IF(B1>10,"value","")

These formulas will return the word

valuewhen the criteria are met and display a blank cell if not.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Europe's new data protection laws will affect you?

Discuss in The Lounge

Poll History