Thread
:
further if problem
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ardus Petus
external usenet poster
Posts: 718
further if problem
=IF(LEFT(A1,2)="AB",Something,"")
HTH
--
AP
"sedonovan" a écrit dans le message de
news:
...
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)
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus