false if no value

  1. 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...
    • MARIE15
    • Thread
    • false if no value nest formula nested "if statements"
    • Replies: 5
    • Forum: Excel Questions
  2. K

    Hide False result in cell when using nested if and vlookup formula

    Hey, I have a formula, below, that returns "False" until the user has filled out certain fields. How can I have it hide "false"? The IFERROR is not working. =ERROR(IF(C3="Reschedule","Schedule",IFC$="Yes","Schedule",IF(C4-"No",VLOOKUP(C7,'Diagnosis Solutions'!A1:G10,6,FALSE))))"")
  3. R

    Macro Pivot Table Issue

    Hello, I am creating a macro that creates several pivot tables. These tables each filter out a set of data. If the report I run the macro on, one day, has no results for one of those sets of data, the macro results in an error. The error states "Unable to set visible property of PivotItem...
  4. A

    Need macro with vlookup formula to transfer data 1 cell to the right

    I need a macro where I use the vlookup formula to get data from a different sheet, where multiple values may be retrieved, then inserting data into the next cell over (to the right) creating a running list. Eg: Lookup value is in column a. Retrieve data and put into column b. When more data is...
    • arroldm
    • Thread
    • false if no value macro move data right vlookup
    • Replies: 0
    • Forum: Excel Questions

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