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)