boolean function

  1. R

    CHOOSE function with Boolean expressions vs. Too many nested IF functions

    Hi, my first time posting. Would really appreciate any help :). I have a file showing products in one column and the volume of each product in another. I am trying to create a list of products groupings (CONCATENATE) based on the cumulative volume of the products. Within my source data each...
    • Reynola5
    • Thread
    • boolean function choose function excel nested if function
    • Replies: 4
    • Forum: Excel Questions
  2. O

    Check is range is logical

    Hi, I have 3 columns that are either true or false. For every row there can only be one true. I want to create a column that checks this, not using any macro. I understand I can make a nested formula with many ifs, but it seems like there should be a simpler way. Is there?
  3. K

    Creating a function with a Boolean variable

    I'd appreciate any insight from someone experience with writing VBA functions. I am trying to write a function that returns a Boolean value. The function has two arguments, a Range argument and string argument. The function is supposed to take the value of a string and search a range for...
  4. U

    What Data Type do you use for Boolean plus one. True, False and TBD

    I have a complicated routine that I am writing that would normally be Boolean but there are a few times when the answer will be To Be Determined. There are some that are clearly defined with a lot of IF THEN ELSE statements but when all is said and done, there will be three answers. There are a...
  5. A

    VBA equaivalent of worksheet functions

    Hi, new to using excel VBA and struggling... Is there a VBA equivalent to this formula? =IF(ISNUMBER(FIND("mytext",A3)),"good","bad") I have defined a range in VBA and need to create a VB module to do check the range for certain text and based on the result output the result to an offsett...

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