Microsoft Office Forums - View Single Post - [Solved] struggling with Excel formula

Thread: [Solved] struggling with Excel formula

View Single Post

Old

05-02-2014, 07:21 AM

momentman

momentman is offline

momentman uses Windows 7 64bit

Windows 7 64bit momentman uses Office 2010 32bit

momentman uses Office 2010 32bit

Office 2010 32bit

Novice

Join Date: Apr 2014

Location: Nigeria

Posts: 5

momentman is on a distinguished road

Default

Do you mean something like this, based on whats in the worksheet

=IF(S3="",'P:\PRODUCTION\INTAKE\GRADING SHEETS\2014\[Grading Sheet Week 16.xlsx]16103-14'!$M$27,S3*P3)

Reply With Quote