Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions |