divide the final value

Hello all,

I have a forumla that works fine but I need to divide the final value.

This works fine:

=(TLP!C23)-(TLP!C23*$AD$18%)+($B$15*A17/1000000*$AD$19)

But when I add the divide part at the end it doesnt work

=(TLP!C23)-(TLP!C23*$AD$18%)+($B$15*A17/1000000*$AD$19)/$AD$17

if I change the '/' to '+' the foruma works, just not with '/'

Very confused lol

Cheers,

JJ

It just ignores the value?

I am using office 2007, maybe a bug?

OK thanks, I will google issues with 2007.

Thanks again for the quick reply.