Simple IF problem

I have following expression but giving me wrong output.Pls help me to solve it

=IF(E8="BA1",(T8/1.125)-((T8/1.125-164.8)/1.103))-260,(T8/1.125)-((T8/1.125-164.8)/1.103)

where T8=5220 AND E8="BA1"

and result should be =322.70
but it is giving me wrong output by making my expession like as follows

=IF(E8="BA1",(T8/1.125)-((T8/1.125-164.8)/1.103))-260*(T8/1.125)-((T8/1.125-164.8)/1.103)

pls help me to solve and also teach or explain me why it is converting like this ..
Thanks in advance

Originally Posted by Colin Legg

Hi,

Your original formula is invalid because you have one too many ) brackets in the middle and you are missing one at the end, so Excel tries its best to interpret what the formula should be. Obviously Excel's interpretation is wrong - but it does give you a prompt to let you know that it made a guess (it gives you the option to amend it yourself).

Your current formula is:
=IF(E8="BA1",(T8/1.125)-((T8/1.125-164.8)/1.103))-260,(T8/1.125)-((T8/1.125-164.8)/1.103)

It should be this:
=IF(E8="BA1",(T8/1.125)-((T8/1.125-164.8)/1.103)-260,(T8/1.125)-((T8/1.125-164.8)/1.103))

Which can be simplified to:
=(T8/1.125)-((T8/1.125-164.8)/1.103)-IF(E8="BA1",260)

Thanks for reply
I tried something like this but again same error

=IF(P10="BA1",(N11/1.125)-H11-G11-E11-((N11/1.125)-((N11/1.125-164.8)/1.103)))-260,(N11/1.125)-H11-G11-E11-((N11/1.125)-((N11/1.125-164.8)/1.103))

now there all brackets are equal pls tell me where is mistake

thanks in advance

It can be tricky counting all those brackets, so try copying the line into a text editor and manually add line feeds and nested indentation to get a clearer picture of what's there. With your statement, this is what I get:

Please Login or Register  to view this content.

It looks like you're still closing the IF off too early. That bracket on the left hand margin before the -260 needs to come out of there and go on the end.