# If Then Statement

##### New Member
Hi All, I have the following code which tests to see if the value in column J is a "Y":

For x = 7 To Counter

Range("E" & x).Formula = "=if(\$J\$" & x & "=Y,\$D\$" & x & " * .025,0)"

Next x

I am not sure how to show the "Y" with quotes in the formula. Without the quotes it bombs. I tried using the single ticks 'Y' but this did not work either. Any help would be appreciated.

Regards,
Bill Mahoney

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Hi All, I have the following code which tests to see if the value in column J is a "Y":

For x = 7 To Counter

Range("E" & x).Formula = "=if(\$J\$" & x & "=Y,\$D\$" & x & " * .025,0)"

Next x

I am not sure how to show the "Y" with quotes in the formula. Without the quotes it bombs. I tried using the single ticks 'Y' but this did not work either. Any help would be appreciated.

Regards,
Bill Mahoney

Try this:

Range("E" & x).Formula = "=if(\$J\$" & x & "=""Y"",\$D\$" & x & " * .025,0)"

Or, you can do this:

Range("E" & x).Formula = "=if(\$J\$" & x & "=" & Chr(34) & "Y" & Chr(34) & ",\$D\$" & x & " * .025,0)"

Chr(34) is the double-quote.

HTH,

Russell

Thanks for the help.

Regards,
Bill Mahoney

Replies
24
Views
690
Replies
7
Views
156
Replies
4
Views
298
Replies
6
Views
219
Replies
7
Views
838

1,219,997
Messages
6,151,369
Members
451,023
Latest member
dwalc

### 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.

### Which adblocker are you using?

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

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