Posted to microsoft.public.excel.worksheet.functions
|
|
IF-Then formula problem
Thanks, Max. It worked like a charm. -Bill
"Max" wrote:
Believe you meant to do this:
=IF(AND(M2-L20,M2-L2<MaxTAT),ROUND((M2-L2)*1440,0),"")
[Using an AND construct, and with extra parens removed]
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bill Elerding" wrote:
I am using the attached formula, but need to modify it to within a range.
Here is the existing formula:
Formula =IF((M2-L20),(ROUND(((M2-L2)*1440),0))," ")
I need to have the first IF statement to me like this, where MaxTAT=180
(for now):
Revision =IF((MaxTATM2-L20),(ROUND(((M2-L2)*1440),0))," ") I want the
formula to round the answer if M2-L2 is between 0 and 180, or leave it blank
if not. When I put the formula in as this, it appears to only consider the
M2-L20 part of the formula. Am I missing something REALLY basic here?
Thanks for any help. Bill in Northern California
|