ExcelBanter - I want a blank space on a worksheet when the question is blank?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I want a blank space on a worksheet when the question is blank? (https://www.excelbanter.com/excel-discussion-misc-queries/31894-i-want-blank-space-worksheet-when-question-blank.html)

Patrizia

I want a blank space on a worksheet when the question is blank?

I have an If statement the checks a value of one...when the cell is blank the
IF statement return a false...I would like the a blank space if there is no
info in the value cell.

Barb R.

What is your IF statement? I'm not following exactly what you are checking.

"Patrizia" wrote:

I have an If statement the checks a value of one...when the cell is blank the
IF statement return a false...I would like the a blank space if there is no
info in the value cell.

Dave Peterson

=if(a1=1,"ok","")

(I think???)

Patrizia wrote:

I have an If statement the checks a value of one...when the cell is blank the
IF statement return a false...I would like the a blank space if there is no
info in the value cell.

--

Dave Peterson

All times are GMT +1. The time now is 12:57 PM.