| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I used a nested IF function in excel-calculates only 1st IF?
untested so you may have to adjust right )))). Quit using the old lotus 123
sum(............ =IF(B45="T",g15,IF(B45="G",G13,IF(B45="GG",G14,IF( B45="GW",G16)))))*c45 -- Don Guillett SalesAid Software "Cojo" wrote in message ... I am working with Excel. I have created a formula with a Nested If statement. ex. of formula: =IF(B45="T",SUM(G15*C45,IF(B45="G",SUM(G13*C45,IF( B45="GG",SUM(G14*C45,IF(B45="GW",SUM(G16*C45)))))) )) When I test this formula out I will get the right outcome when I use "T" but to use any other letters it will give me a FALSE outcome. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF Function problem for Excel 2003 | Excel Worksheet Functions | |||
| Excel 2007 nested function | Excel Worksheet Functions | |||
| Need a function that calculates time between 2 dates | Excel Worksheet Functions | |||
| Copying the cell contents(a math function) that calculates a numbe | Excel Programming | |||
| If function that calculates | Excel Worksheet Functions | |||
Hybrid Mode
