setting cell value to nullwithif statement

wmtsub

Active Member
Joined
Jun 20, 2018
Messages
322
often I will clear a cells value with an if statement
=if(condition) then, "Action","").
My issue is with the "".
Instead of setting the cell to "" how to I just make it a blank cell?
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Yes it is blank, but I do not want it to be blank. I want it to be the same as an unused cell.

I thought unused cells were blank but there not.
 
Upvote 0
if you set a cell to "" it is not the same as an unused cell. Certain functions see a 0 and some do not. i am looking to reset the cell to an unused state not a null state.
 
Upvote 0
Do you have formulae in those cells?
 
Upvote 0
Then I don't understand your problem. you originally said
often I will clear a cells value with an if statement
=if(condition) then, "Action","").
But now you are saying there are no formulae in those cells :confused:
 
Upvote 0
So i think you clear the cells with a formula then delete the formulas? So something like counta(A1) would still produce 1? Use text to columns? This will make counta produce 0.
 
Upvote 0
often I will clear a cells value with an if statement
=if(condition) then, "Action","").
My issue is with the "".
Instead of setting the cell to "" how to I just make it a blank cell?
If you have a formula in a cell, then the cell cannot be blank (like when nothing is in a cell) because it has something in it... the formula. The only way is to run a macro that looks for cells displaying "" and have that macro physically clear the cell. Of course, that means the formula will no longer be there when you make changes that the now missing formula would have reacted to by displaying something other than "".
 
Upvote 0

Forum statistics

Threads
1,223,908
Messages
6,175,306
Members
452,633
Latest member
DougMo

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