It is easier than you are making it...

=if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue))
--
HTH...

Jim Thomlinson


"caz - can't use excel!!" wrote:

=IF(B6=IN,A6+C6)*OR(B6=OUT,A6-C6)...........The first part of the formula
works but the cell won't recognise the second part!! I need cell B6 to do 1
sum if I enter IN and another sum if I enter OUT?? Any ideas please???

Caz