Solved Say input B1 and formula B2, Than i want B1 8 and 10 in B2

March 12, 2014 at 05:06:58
Specs: Windows 7
Inpute=B1, Formula=B2, Formula=B3

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

in B3 , B1>10 = value


See More: Say input B1 and formula B2, Than i want B1 8 and 10 in B2

Report •

#1
March 12, 2014 at 08:36:15
✔ Best Answer
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 value when 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.


Report •
Related Solutions


Ask Question