if not blank

  1. J

    Formula to find column value with ticked/filled cells for Google Sheets

    I have a question about what formula I should use for the following: I have a spreadsheet (similar to below). Across the columns are values such as A, B, C etc. Down the rows are item numbers. I have one table which has these items down the rows and ticks next to the relevant column value. E.g...
  2. D

    Requiring a user to give a response with VBA and Data Validation

    I have a data validation set in 3 columns so that the answers will remain consistent, and I don’t want this to change. I want cell D to be required if cell B has an answer selected (which will always be “Yes” because of my data validation restriction). But I don’t want cell D to be required if...
  3. A

    Calculate if not blank and sum without errors

    Hello everyone - I was hoping to get a little help with this formula (in COL BE2), please: =IF(AND($AP2="x",$AW2="L",I3>BC2),J3-AY2,IF(AND($AP2="x",$AW2="S",H3<BC2),AY2-J3,IF(AND($AP2="x",$AW2="L",I3<=BC2),BC2-AY2,IF(AND($AP2="x",$AW2="S",H3>=BC2),AY2-BC2,"")))) It does what it is supposed...
  4. L

    IF not blank conditional formatting formula help

    Hi, I'm wanting to format cells in worksheet 1 to insert a hyperlink in a cell if a cell in worksheet 2 is not blank. I also want to color the cell at the same time if the cell in worksheet 2 is not blank. where do I start with this 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