Quote Originally Posted by Colin Legg View Post
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