I need some assistance with IF statement
I need a formula that will look at a range of cells for a certain "text". If the text matches then it will display some test in the cell. Simple. I can get the formula to work when looking at just one cell, but I can figure out how to make it look at a range of cells. Here is my formula
=IF(B3="KV","Pump Stand",IF(B3="KS","Pump Stand",""))
So instead of just looking at cell B3 I need it to look a cell range B3 through Z3.
Any ideas?
welcome to the forum, billylasvegas. this will give you the total count of cells with either the word "KV" OR "KS"
=SUM(COUNTIF(B3:Z3,{"KV","KS"}))
so if that is >0, i suppose you will label it as "Pump Stand"?
=IF(SUM(COUNTIF(B3:Z3,{"KV","KS"}))>0,"Pump Stand","")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi and welcome to the forum
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
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
Re: I need some assistance with IF statement
This worked perfect, thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks