IF trouble
 

=IF(F5="STANDARD",J28,IF(F5="CUSTOM",IF(J8<1999,(( 2000*D7)/D11)*(J28)/F6),SUM(D26:D27)))

This formula is working like a charm....until the last SUM(D26:27) that is.
It is suppose to determine if CUSTOM is entered and the number of lineal feet
is less than 1999 then the cell should return ((2000*D7)/D11)*(J28)/F6), if
not, then it should return the sum of D26:D27. BUT, when I enter anything
over 1999 LF, the cell returns a FALSE value. Can someone help?

IF trouble
 

Your parens weren't aligned correctly. Try:

=IF(F5="STANDARD", J28, IF(F5="CUSTOM", IF(J8<1999,
((2000*D7)/D11)*(J28)/F6,SUM(D26:D27)), "Neither Standard Nor Custom"))

In article ,
Rah wrote:

=IF(F5="STANDARD",J28,IF(F5="CUSTOM",IF(J8<1999,(( 2000*D7)/D11)*(J28)/F6),SUM(
D26:D27)))

This formula is working like a charm....until the last SUM(D26:27) that is.
It is suppose to determine if CUSTOM is entered and the number of lineal feet
is less than 1999 then the cell should return ((2000*D7)/D11)*(J28)/F6), if
not, then it should return the sum of D26:D27. BUT, when I enter anything
over 1999 LF, the cell returns a FALSE value. Can someone help?

IF trouble
 

THANK YOU VERY MUCH. IT WORKED!

"JE McGimpsey" wrote:

Your parens weren't aligned correctly. Try:

=IF(F5="STANDARD", J28, IF(F5="CUSTOM", IF(J8<1999,
((2000*D7)/D11)*(J28)/F6,SUM(D26:D27)), "Neither Standard Nor Custom"))

In article ,
Rah wrote:

=IF(F5="STANDARD",J28,IF(F5="CUSTOM",IF(J8<1999,(( 2000*D7)/D11)*(J28)/F6),SUM(
D26:D27)))

This formula is working like a charm....until the last SUM(D26:27) that is.
It is suppose to determine if CUSTOM is entered and the number of lineal feet
is less than 1999 then the cell should return ((2000*D7)/D11)*(J28)/F6), if
not, then it should return the sum of D26:D27. BUT, when I enter anything
over 1999 LF, the cell returns a FALSE value. Can someone help?