hi again,
i wonder if you could help further to previous answers?
i need to develop an IF formula so that if one cell = AB it performs the
calculation, if it = AC it returns an empty cell (NOT ZERO
though!).
AB and AC will be followed by various digits,
eg
AB01
AB02
AC03
AB04
AC05
AB06

the two values will only ever be AB or AC. so actually it depends on the 2nd
character of the string - whether it's B or C
help AGAIN please!
thanks!
:o)