Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
further if problem
hi again,
i wonder if you could help further to previous answers? i need to develop an IF formula so that if one cell = AB it performs the calculation, if it = AC it returns an empty cell (NOT ZERO though!). AB and AC will be followed by various digits, eg AB01 AB02 AC03 AB04 AC05 AB06 the two values will only ever be AB or AC. so actually it depends on the 2nd character of the string - whether it's B or C help AGAIN please! thanks! :o) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
further if problem
=if(mid(A1,2,1)="B",DoCalulation,"")
refer to your pervious post Regards FSt1 "sedonovan" wrote: hi again, i wonder if you could help further to previous answers? i need to develop an IF formula so that if one cell = AB it performs the calculation, if it = AC it returns an empty cell (NOT ZERO though!). AB and AC will be followed by various digits, eg AB01 AB02 AC03 AB04 AC05 AB06 the two values will only ever be AB or AC. so actually it depends on the 2nd character of the string - whether it's B or C help AGAIN please! thanks! :o) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
further if problem
=IF(LEFT(A1,2)="AB",Something,"")
HTH -- AP "sedonovan" a écrit dans le message de news: ... hi again, i wonder if you could help further to previous answers? i need to develop an IF formula so that if one cell = AB it performs the calculation, if it = AC it returns an empty cell (NOT ZERO though!). AB and AC will be followed by various digits, eg AB01 AB02 AC03 AB04 AC05 AB06 the two values will only ever be AB or AC. so actually it depends on the 2nd character of the string - whether it's B or C help AGAIN 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) |