if problem
 

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)

if problem
 

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

"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)

if problem
 

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)

if problem
 

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)

if problem
 

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)

if problem
 

=if(left(A1,2)= "AB",DoCalculation,"")
regards
FSt1

"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)