View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robnet robnet is offline
external usenet poster
 
Posts: 9
Default I Then logic help

Ok. I would think this simple but can't figure it out..
If value cell 'A1" = True
then paset contents of cell from different sheet in same workbook.


=IF(J10,'4. Environment IP Addresses'!B6," ")

The above value is true, but I recieve a #VALUE! error.

Any help is appreciated. Thanks!