Can I use the if function and use it against multiple cells.
Can I say, if cell a1>65 and a7 is equal to "silver", then return a value of "Yes", if not then return a value of "No"
Can I use the if function and use it against multiple cells.
Can I say, if cell a1>65 and a7 is equal to "silver", then return a value of "Yes", if not then return a value of "No"
I think this is the wrong forum, so I will move it for you.
In the mean time try this...
=IF(and(A1>65,A7="Silver"),"Yes","No")
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks