|
|
#3
01-03-2014, 06:57 AM
|
|||
|
|||
I appreciate the help but that didn't work. I assume that as part of the formula you wrote the value of U should be between the quotes. So for example, my value in U is 2440 and my value in W is .80.
So if I go by your formula it should read: =IF(and(W1>0.1,W1<0.5),U1,"2440") Is that correct? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using if statement many times! | Jamal NUMAN | Excel | 6 | 01-19-2012 12:05 PM |
| IF Statement and Macros | kannon | Excel Programming | 2 | 01-06-2012 02:51 AM |
 Help with IF Statement
|
limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |
|
if statement
|
piper7971 | PowerPoint | 1 | 08-19-2010 07:10 AM |
|
Help with IF statement!
|
CPelkey | Word | 1 | 04-12-2010 09:06 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode