#1
|
|||
|
|||
struggling with Excel formula
Hi can someone please help me.
I have attached a file to this. what im trying to do is this; Using row 3 as an example; I would like cell O3 to draw from ='16102-14'!$M$27 When S3 is blank. however when S3 has a value I would like O3 to state the value of S3 multiplied by the % value in cell P3 as is stated when S3 is Blank. I hope this explanation makes sense. any questions let me know. Thanks |
#2
|
|||
|
|||
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) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with excel formula | GoldenSlumbers | Excel | 2 | 12-13-2012 03:32 AM |
Excel Formula | oRie | Excel | 2 | 02-28-2012 07:48 PM |
** Excel Formula | djreyrey | Excel | 8 | 04-15-2011 03:55 PM |
Excel Formula Help | masoom84 | Excel | 1 | 03-07-2009 09:41 AM |
Excel Formula Help | Shahzad | Excel | 1 | 12-07-2008 04:13 AM |