It also works , thanks Ravi da
On Mon, Jul 28, 2014 at 1:24 PM, Ravi Kumar wrote:
> another way
>
> =CHOOSE(MATCH(A1,{"red","sta","ida","pco","pid","pde"},0),"us2","ru2","cu2","us3","ru3","cu3")
>
>
> On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain wrote:
>>
>> Dear all , how to merge following six
another way
=CHOOSE(MATCH(A1,{"red","sta","ida","pco","pid","pde"},0),"us2","ru2","cu2","us3","ru3","cu3")
On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain wrote:
> Dear all , how to merge following six formula into single formula.
> small formula is required . Thanks
>
> IF(A1="red","us2","")
>
>
Awesome!.Vaibhav Sir.
Thanks a Lot!
Regards,
Prafull Jadhav
9920553518
On 28 July 2014 12:28, Vaibhav Joshi wrote:
> hi
>
> you cont need such formula.. use this
> formula =A1-MOD(A1,10)&"-"&A1-MOD(A1,10)+10
>
> It is modeless whatever be the range yo have your answer!!
>
> Cheers!!
>
>
hi
you cont need such formula.. use this
formula =A1-MOD(A1,10)&"-"&A1-MOD(A1,10)+10
It is modeless whatever be the range yo have your answer!!
Cheers!!
On Mon, Jul 28, 2014 at 12:19 PM, Prafull Jadhav
wrote:
> Dear Vaibhav Sir,
> Your formula is very good,Appreciate!
> Can we do the same fo
Dear Vaibhav Sir,
Your formula is very good,Appreciate!
Can we do the same for bucket by using same technique.
for example
0-10,11-20,21-30
if cell is contain
7 then it should be come under 0-10 bucket
if cell is contain
22 then it should be come under 21-30 bucket.
Regards,
Prafull Jadhav
99205
Dear Joshi da, it works perfectly & thanks for your different idea
except IF formula..
On Sat, Jul 26, 2014 at 1:51 PM, Vaibhav Joshi wrote:
> you can also use:
>
> =VLOOKUP(A1,{"red","us2";"sta","ru2";"ida","cu2";"pco","us3";"pid","ru3";"pde","cu3"},2,0)
>
> Cheers!!
>
>
> On Sat, Jul 26, 2014
you can also use:
=VLOOKUP(A1,{"red","us2";"sta","ru2";"ida","cu2";"pco","us3";"pid","ru3";"pde","cu3"},2,0)
Cheers!!
On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain wrote:
> Dear all , how to merge following six formula into single formula.
> small formula is required . Thanks
>
> IF(A1="red","
Your Welcome..
On Sat, Jul 26, 2014 at 9:48 AM, Nur Hossain wrote:
> Hi Pramod da,
>
> It works perfectly , thanks for your supports
>
>
> On Sat, Jul 26, 2014 at 9:58 AM, Pramod Singh wrote:
> > H Nur,
> >
> > Your Formula will be
> >
> =IF(A1="Red","us2",IF(A1
Hi Pramod da,
It works perfectly , thanks for your supports
On Sat, Jul 26, 2014 at 9:58 AM, Pramod Singh wrote:
> H Nur,
>
> Your Formula will be
> =IF(A1="Red","us2",IF(A1="Sta","ru2",IF(A1="Ida","Cu2",IF(A1="Pco","Us3",IF(A1="Pde","Cu3","")
>
>
> Regards
> Pramod
>
>
> On Sat, Jul 26
H Nur,
Your Formula will be
=IF(A1="Red","us2",IF(A1="Sta","ru2",IF(A1="Ida","Cu2",IF(A1="Pco","Us3",IF(A1="Pde","Cu3","")
Regards
Pramod
On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain wrote:
> Dear all , how to merge following six formula into single formula.
> small formula is requir
Dear all , how to merge following six formula into single formula.
small formula is required . Thanks
IF(A1="red","us2","")
IF(A1="sta","ru2","")
IF(A1="ida","cu2","")
IF(A1="pco","us3","")
IF(A1="pid","ru3","")
IF(A1="pde","cu3","")
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
11 matches
Mail list logo
