View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chachg Chachg is offline
external usenet poster
 
Posts: 1
Default Two answers to a true "If": =if(a,b*and c,d)?;b&C true, d false?

I wish to do two things if my "IF" statement is true: add "1" to a counter,
and post the new value of the counter to a different cell. e.g.,

=(IF(A6="F"),(($T4=$T4+1)*AND(B6=$T4))).
(true)

The function appears to be valid (I get no notice that it's wrong) but
neither of the "true" actions takes place. i.e., the counter (in T4) doesn't
get changed, and no value appears in "B6", so.....

Can one take two actions if the IF statemtnt is true? If so, what do I need
to do?