Thread: IF trouble
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rah
 
Posts: n/a
Default 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?