Solved Using IF, AND, OR statements

March 28, 2014 at 06:43:40
Specs: Macintosh
I have created a statement that functions, but shows only true or false if it meets the requirements, and for the other statement it show what is desired. I would like the cell to show "First Warning if the following is met. if B3="FT" and E3>=6, then H3 should display "First Warning, If b3="PT" and E3 >=6 then H3 should display "First Warning" if the requirement are not met the H3 should be blank. I can make one function at time with but not both.

See More: Using IF, AND, OR statements

Report •

March 28, 2014 at 07:40:28
✔ Best Answer
How about this:

=IF(AND(E3>=6,OR(B3="FT",B3="PT")),"First Warning","")

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

Report •
Related Solutions

Ask Question