if problem

S

sedonovan

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!
:eek:)
 
D

Danny Lewis

Say A1 is either AB or AC
and B1 is the calculation eg =SUM(B5:B10)

change B1 to =if(A1="AB",SUM(B5:B10),"NULL")

Danny
 
F

FSt1

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
 
S

sedonovan

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!!
 
Top