nested cell reference

  1. S

    Nested if functions for part of a text string

    Hello! and thank you for helping me find a solution to this problem. Right now I have a very long nested function that has around 200 if statements and left functions. The function works great, but I can only go as far as 64. The purpose of this function is to get part of a string in a cell and...
    • SM2292
    • Thread
    • left nested "if statements" nested cell reference nested formulas nested if or and multiple
    • Replies: 0
    • Forum: Excel Questions
  2. R

    Using a formula as a cell reference

    This seems like it would be simple...I'm trying to find a way to use a the results of a function as a cell reference in a range. For instance, if I have a column of 25 numbers, say B1:B25, and I want to select a range from B1 to a row specified by another function--let's say the result from...

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