try using the formula =IF(LEFT(A1,2)="AB",DoCalculation,"NULL"

"sedonovan" wrote:

sorry, should have mentioned that AB and AC will be followed by various
digits, these are the PRE-FIXES
eg
AB01
AB02
AC01
AC02

but I only want to perform calculations on any *beginning* AB!!

"FSt1" wrote:

hi,
not sure where everything is at but...
=if(A1=AB,DoCalulation,"")
if the target cell, in this case A1, has AB in it, the formula will perform
your calulation. if not then the cell will seem empty(null).
hope this helps
regards,
FSt1

"sedonovan" wrote:

hi everyone,
i wonder if you could help? i need to develop an IF formula so that if one
cell AB it performs the calculation, if it = AC it returns null (NOT ZERO
though!). the two values will only ever be AB or AC.
help. please!
thanks!
:o)