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

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

You need to amend your formula like this:

=IF(AND(MaxTATM2-L2,M2-L20),ROUND((M2-L2)*1440,0)," ")

I've also removed two pairs of redendant brackets.

Hope this helps.

Pete

On Mar 24, 6:47*pm, Bill Elerding <Bill
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

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

Great, thanks for the help. Of course, once I put in the fix, I had to also
remember to multiply the M2-L2 by 1440 to convert the times back to minutes.
Sometimes the simplest things... -Bill

"Pete_UK" wrote:

You need to amend your formula like this:

=IF(AND(MaxTATM2-L2,M2-L20),ROUND((M2-L2)*1440,0)," ")

I've also removed two pairs of redendant brackets.

Hope this helps.

Pete

On Mar 24, 6:47 pm, Bill Elerding <Bill
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

Good to hear that, and thanks for feeding back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bill Elerding" wrote in message
...
Thanks, Max. It worked like a charm. -Bill

Yes, I thought you were doing something with time. Glad to hear you
got it to work.

Pete

On Mar 25, 5:59*am, Bill Elerding
wrote:
Great, thanks for the help. *Of course, once I put in the fix, I had to also
remember to multiply the M2-L2 by 1440 to convert the times back to minutes. *
Sometimes the simplest things... *-Bill



"Pete_UK" wrote:
You need to amend your formula like this:

=IF(AND(MaxTATM2-L2,M2-L20),ROUND((M2-L2)*1440,0)," ")

I've also removed two pairs of redendant brackets.

Hope this helps.

Pete

On Mar 24, 6:47 pm, Bill Elerding <Bill
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- Hide quoted text -

- Show quoted text -