nest formula

  1. F

    Adding spaces into a nested formula

    Does anyone know how I can add the "#####" into a formula? essentially what I'm trying to accomplish is adding 5 leading spaces before returning value. e.g. If the returning value is "Students" then it should look like this Students (5 spaces before the returning value) Students (no...
  2. M

    Removing "Blank" Result from cell

    I am using a formula in which the results "low", "medium, or "high" will appear (in column U) based on the numerical value that is entered in another cell (in column T). =IF(T3<>"",IF(T3<=59,"LOW",IF(T3<=79,"MEDIUM",IF(T3>=79,"HIGH","")))) It works perfectly, however the word "FALSE" is shown...
  3. H

    Nesting with "does not contain" function

    Hi all, I have a report that I am trying to automate as it just takes far too long to complete it manually. As main reference to edit my data, I have different titles from different jobs which the naming is not consistent. What I want to do, is identify which jobs are not in UK language, and...
  4. L

    Nested if statement to look in between multiple date columns to see if tag is applicable based on 1 date

    Hi everyone, I need help writing a nested if statement to solve for the "desired result" column. I need to look in between each of these dates and determine which was most recent to the "comparison date", and display the "desired result" tag. The combinations on this are driving me crazy and I...
  5. A

    Excel vba coding to replace each string to different text or nest formula?

    Hello, I'm trying to replace 100 cells in a column that has different values. The result will be in another column that identify the first letter of that cell and replace with one the 3 names in all selected rows (Mary, Thomas, Hilton). I believe a VBA code would be easier than a nest formula...

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