Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF-Then formula problem
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) | |||
problem with formula | Excel Discussion (Misc queries) | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) |