literal

  1. A

    Using Enum

    I have a list of strings and numbers that go with them. I'm sending the string to a Function to return the Number and was using Select Case but have an idea there's something better. I tried Enum. Can I use the variable name though, or must be a literal ?
  2. B

    Is there a way to put the only the results of a formula in a different cell.

    I am looking for a way to put the results of a formula in a different cell without any formula appearing in the new cell, sort of like "Paste Special/Values" only doing it automatically with a formula or function, instead of manually. For example, if the results of a function are "George", I...
  3. B

    IF function returning "TRUE"/"FALSE" literals rather than arguments entered

    I am having trouble with an Excel IF function. If I have a valid child project ID in column K (> 8 characters), then I want to use it to populate my cell. Otherwise, I want to populate my cell with the parent project ID in column J. Here is my IF statement. =IF(LEN(K2)<8,J2,K2) The result I...

Watch MrExcel Video

This Week's Hot Topics

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
Top