View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] arogg@payroll.nyc.gov is offline
external usenet poster
 
Posts: 6
Default If function across sheets prints value of cell

On Monday, May 14, 2012 11:49:16 AM UTC-4, New_to_accounting wrote:

Sheet1!C3


Not sure exactly what that means. I did try that as the false value
but it just populates that. Not the actual contents of cell C3 on
Sheet1


He means you have to remove the quotation marks around the false condition if you want the value to display:

=IF(Sheet1!C1=0," ",Sheet1!C3)

Allan Rogg