|
|
#2
10-06-2011, 10:23 AM
|
|||
|
|||
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) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reporting ManDays on people not fully assigned to the Project | Imagios | Project | 9 | 10-10-2011 04:36 AM |
| Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
| Resource Overallocation Reporting | Mutso | Project | 0 | 11-05-2010 12:27 PM |
| Outlook reporting from mail merge?? | jondoyle24 | Outlook | 0 | 10-18-2010 06:44 AM |
| Project Reporting | vickib1 | Project | 0 | 09-08-2010 03:11 AM |
Reporting Values Between Sheets/Tabs
Windows Vista 
Office 2007
Threaded Mode