software

=IF(F5=quot;STANDARDquot;,J28,IF(F5=quot;CUSTOMquot;,IF(J8lt;1999,(( 2000*D7)/D11)*(J28)/F6),SUM(D2627)))

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 D2627. BUT, when I enter anything
over 1999 LF, the cell returns a FALSE value. Can someone help?

Your parens weren't aligned correctly. Try:

=IF(F5=quot;STANDARDquot;, J28, IF(F5=quot;CUSTOMquot;, IF(J8lt;1999,
((2000*D7)/D11)*(J28)/F6,SUM(D2627)), quot;Neither Standard Nor Customquot;))

In article gt;,
Rah gt; wrote:

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

THANK YOU VERY MUCH. IT WORKED!

quot;JE McGimpseyquot; wrote:

gt; Your parens weren't aligned correctly. Try:
gt;
gt; =IF(F5=quot;STANDARDquot;, J28, IF(F5=quot;CUSTOMquot;, IF(J8lt;1999,
gt; ((2000*D7)/D11)*(J28)/F6,SUM(D2627)), quot;Neither Standard Nor Customquot;))
gt;
gt; In article gt;,
gt; Rah gt; wrote:
gt;
gt; gt; =IF(F5=quot;STANDARDquot;,J28,IF(F5=quot;CUSTOMquot;,IF(J8lt;1999,(( 2000*D7)/D11)*(J28)/F6),SUM(
gt; gt; D2627)))
gt; gt;
gt; gt; This formula is working like a charm....until the last SUM(D26:27) that is.
gt; gt; It is suppose to determine if CUSTOM is entered and the number of lineal feet
gt; gt; is less than 1999 then the cell should return ((2000*D7)/D11)*(J28)/F6), if
gt; gt; not, then it should return the sum of D2627. BUT, when I enter anything
gt; gt; over 1999 LF, the cell returns a FALSE value. Can someone help?
gt;