Thread: [Solved] Reporting Values Between Sheets/Tabs
View Single Post
 
Old 10-06-2011, 10:23 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
you are not using all the arguments of the IF function: IF(logical test;value if true;value if false)
Your formula is missing the value if false! If you omit that, excel will display false if the logical test is not true.
You can try: =IF('Sheet1'!R8="Y",'Sheet1'!A8,"")
or: =IF('Sheet1'!R8="Y",'Sheet1'!A8,0)
Reply With Quote