| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have some problem with database | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
