IF trouble

R

Rah

=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?
 
J

JE McGimpsey

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"))
 
R

Rah

THANK YOU VERY MUCH. IT WORKED!

JE McGimpsey said:
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"))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the number of Instances 4
Worksheet data entry form by Dave Peterson 2
Summing from multiple wksts - incomprehensible #VALUE error 9
Peo Sjoblom: multi lookup 3
A UDF for Counting Coloured Cells that are conditionally formatted 5
MSExcel and SAP 0
Control SAP from Excel via COM 7
Random numbers appearing, calculations showing as zero 6

Top