LinkBack URL
About LinkBacks
I am looking for the correct formula for the following:
IF cell D10 is L and cell C10 is 6.0 or greater, then E10 ="x", otherwise, E10 is blank.
I am looking for the correct formula for the following:
IF cell D10 is L and cell C10 is 6.0 or greater, then E10 ="x", otherwise, E10 is blank.
use this in E10
=if(and(D10="L",C10>=6),"x","")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this...
=IF(AND(D10="L",C10>=6),"x","")
re-post: D'OH!
=if(and(d10="L",c10>=6),"x","")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
three times is a charm lol
Many Thanks as always. You guys are the best !!
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks