Thread: [Solved] Need help with If, Then Statement Please
View Single Post
 
Old 01-03-2014, 06:57 AM
cangelis cangelis is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Jan 2014
Posts: 18
cangelis is on a distinguished road
Default
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?
Reply With Quote