View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
caz - can't use excel!! caz - can't use excel!! is offline
external usenet poster
 
Posts: 1
Default Need HELP!! IF OR formula driving me crazy!!!!

=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