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.