| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multisheet IF Function
I am trying to accomplish the following: If the value on Sheet 1 Cell K3 is
blank, then the value on Sheet 2 Cell K3 is automatically left blank. Otherwise, any value entered on Sheet 1 Cell K3 will automatically be copied to Sheet 2 Cell K3. It is possible that the value entered in Sheet 1 Cell K3 is preceeded by one or more zeros, so I have formatted Sheet 2 Cell K3 as 'text'. I have tried the formula =IF(Sheet1!K3=0,"",(Sheet1!K3)) in Sheet2 Cell K3, which doesn't work. Thanks for your help! Regards, Larry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multisheet range in SUMPRODUCT? | Excel Discussion (Misc queries) | |||
| How do I delete the same row in a multisheet spreadsheet | Excel Discussion (Misc queries) | |||
| Select and Insert one sheet from a multisheet excel template | Excel Discussion (Misc queries) | |||
| Multisheet formula | Excel Discussion (Misc queries) | |||
| MultiSheet macro, to sum based on condition | Excel Programming | |||
Threaded Mode
