The "NoValue" part is for when cell B6 contains something other than "IN" or
"OUT". You might want to change the "NoValue" to just "" so that nothing is
displayed for those conditions...

=IF(B6="IN",A6+C6,IF(B6="OUT",A6-C6,""))

--
Rick (MVP - Excel)


"caz - can''t use excel!!" wrote
in message ...
Works without the "novalue" does this make a difference??

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"Jim Thomlinson" wrote:

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