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

  • Thread starter Thread starter caz - can't use excel!!
  • Start date Start date
C

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
 
It is easier than you are making it...

=if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue))
 
"caz - can't use excel!!" <caz - can't use
[email protected] said:
=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???
Click to expand...

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, ""))
 
Try:
=IF(B6="IN",A6+C6,IF(B6="out",A6-C6,""))

If b6 is empty, you get nothing.

Cliff Edwards
 
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,""))
 
Back
Top