double quotes in vba formula

A

almagg

Well-known Member
Joined
Aug 21, 2002
Messages
705
using VBA i will be entering this (with nine other versions):

"=IF(AND($T8="Capital", OR($U8="Overhaul",$U8="800MW-Base")), $K8,0)"

how do i deal with those quotes around Capital, Overhaul and 800MW-Base?

thanks
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
Double up the double quotes

"=IF(AND($T8=""Capital"", OR($U8=""Overhaul"",$U8=""800MW-Base"")), $K8,0)"
 
Upvote 0
Double them up.

"=IF(AND($T8=""Capital"", OR($U8=""Overhaul"",$U8=""800MW-Base"")), $K8,0)"

PS What do you mean by 9 different versions?
 
Upvote 0
i knew it was something simple, but could not find the right search word in the help files.

thanks
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Extracting text within varying length phrases
Replies
8
Views
883
Peter_SSs
Peter_SSs
A
  • Solved
Budget Tracker Issues
2
Replies
14
Views
792
Fluff
Fluff
M
  • Question
Fantasy Calendar Creation stumbling..
Replies
2
Views
135
m26e4u
M
tlc53
  • Question
VBA Save All Relevant Report into One Document
Replies
5
Views
439
tlc53
tlc53
K
  • Question
Looking for assistance using MS Excel VBA to hide rows
Replies
4
Views
345
kcampbell675
K

Forum statistics

Threads
1,215,006
Messages
6,122,665
Members
449,091
Latest member
peppernaut

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top