Need HELP!! IF OR formula driving me crazy!!!!

[caz - can't use excel!!]

=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

 

[Jim Thomlinson]

It is easier than you are making it...

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

 

[JoeU2004]

"caz - can't use excel!!" <caz - can't use

=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???

If B6 can be only "IN" or "OUT", try one of the following equivalent forms,
whichever is easier for you to understand and possibly modify in the future:

=if(B6="in", A6+C6, A6-C6)

=A6 + if(B6="in", C6, -C6)

If B6 can have other values (or none), you need to specify what you want
with B6 is neither "IN" nor "OUT". Try:

=if(B6="in", A6+C6, if(B6="out", A6-C6, ""))

 

[ward376]

Try:
=IF(B6="IN",A6+C6,IF(B6="out",A6-C6,""))

If b6 is empty, you get nothing.

Cliff Edwards

 

[Jim Thomlinson]

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

 

[caz - can''t use excel!!]

You are AMAZING!!! THANK YOU!!!

1 Question though.............How????

 

[caz - can''t use excel!!]

Works without the "novalue" does this make a difference??

 

[Jim Thomlinson]

One answer... Practice...

 

[Rick Rothstein]

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,""))