return blank cell

  1. tlc53

    IF Formula - Isn't returning Blank when I want

    Hi there, I would like cell D310 to return blank, if cell B310 is blank. Both contain an if formula.. Cell B310 =IF(SUM(F310:G310)<>0,433,"") Cell D310 =IF(N(B310)<>"",FYE_Date,"") In this instance, both cells should be blank but cell D310 is returning the FYE Date. Does anyone have any...
    • tlc53
    • Thread
    • blank cell d310 if formula return blank cell
    • Replies: 3
    • Forum: Excel Questions
  2. R

    #NUM! error return blank instead

    I am receiving a #NUM! error. From T2:T39 I have a formula inserted. T2:T5 is showing numbers as numbers are available in working out the formula, T6:T39 is showing #NUM! as there are no numbers available in the formula. Is there a formula I can create under this, T40:T77 that returns the same...
  3. S

    VLOOKUP wanting to include returning blank cell for blank

    I've looked through numerous posts, but can't find the exact answer I need for my VLOOKUP formula forgive me if I'm missing it somewhere. I have included a blank cell in my lookup range and want it to be considered as a valid option. In other words, if a blank cell is found I want a blank cell...
  4. R

    assign blank to E1 cell value (C1 Lis t= E1) without using formula because it returns zero

    The goal of this project is simple: Make the cell E1 (cell in red) default to an empty cell if the cell it is referring to(C1), the cell in green does not have any selection. The following do NOT ok: 1. Setting the defaults in excel to not show cells with 0 values. 2. Do not suggest that we use...

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