ExcelBanter - I want to hide values if no data in target cell

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I want to hide values if no data in target cell (https://www.excelbanter.com/excel-worksheet-functions/117413-i-want-hide-values-if-no-data-target-cell.html)

Steve

I want to hide values if no data in target cell

I'm am using an IF function. I'm typing data in A1 and my IF function value
is in A2. This function is using A1 do determine the value of cell A2. I
don't want values displayed in A2 unless there is data in A1.

Allllen

I want to hide values if no data in target cell

in A2, use

=IF(A1="","",A1)

--
Allllen

"Steve" wrote:

I'm am using an IF function. I'm typing data in A1 and my IF function value
is in A2. This function is using A1 do determine the value of cell A2. I
don't want values displayed in A2 unless there is data in A1.

Allllen

I want to hide values if no data in target cell

or rather

=IF(A1="","",[your calculation here, like maybe 'A1*9/5+32'])

--
Allllen

"Steve" wrote:

I'm am using an IF function. I'm typing data in A1 and my IF function value
is in A2. This function is using A1 do determine the value of cell A2. I
don't want values displayed in A2 unless there is data in A1.

All times are GMT +1. The time now is 11:45 AM.