| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charts/ Graphs and Dates Trouble | Charts and Charting in Excel | |||
| UGH! Trouble downloading, and opening anything | Excel Discussion (Misc queries) | |||
| Time Sheet for my org Im still having trouble | Excel Discussion (Misc queries) | |||
| Trouble opening an Excel file that contains macros | Excel Worksheet Functions | |||
| Maps.........Having Trouble Loading things | Excel Worksheet Functions | |||
Linear Mode
