Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quotes within quotes. Excel

Status
Not open for further replies.
guymason

guymason

Technical User
Apr 25, 2001
125
GB
If I refer to a string in a formula and it has quotes around it, how do I include them in my formula, eg
=IF(C4=""guy"", 10,15) where my input data is "guy" with quotes. Excel doesn't seem to like doubling up quotes.


Thanks
gh
 
Sort by date Sort by votes
Excellent, that's what I wanted, cheers.

guy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
530
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
471
SkipVought
S
N1GHTEYES
  • Locked
  • Question
Count areas within a range 1
Replies
14
Views
1K
SkipVought
S
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
322
combo
combo
renigar
  • Locked
  • Question
Having trouble with Excel Lookup
Replies
5
Views
893
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top