IF-Then formula problem
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
|