doubledragonxx
Distinguished Member
- Joined
- Jan 17, 2007
- Messages
- 3,522
- Reaction score
- 808
- Points
- 1,009
- Age
- 47
Possibly doesn't even need an Excel expert just someone with more Excel knowledge than me which can't be difficult tbh .
So looking for some help with this formula =IF(SEARCH("-P",Sheet1!I923),"X","")
The forumla does the job but for the false value I get a #Value! rather than "" (which should I believe return a blank)
Any pointers where I am going wrong.
So looking for some help with this formula =IF(SEARCH("-P",Sheet1!I923),"X","")
The forumla does the job but for the false value I get a #Value! rather than "" (which should I believe return a blank)
Any pointers where I am going wrong.