The solution already provide in the previous email ..
Regards
Santosh Bahuguna
On Thu, May 12, 2011 at 9:12 AM, irfan khan wrote:
> Hi Rajesh,
>
> I am not clear with you problem, yes u can use "And" function for multiple
> criteria.
> for example
>
> =IF(AND(B4=1212,C4=1117),E4,G4)
> the
Another solution, hope it helps.
Christo
On Thu, May 12, 2011 at 5:21 PM, Rajesh K R wrote:
> Hi Experts,
> Pls find the attached file and solve the issue regarding if function.
>
> Regards
> Rajesh kainikkara
>
> --
>
> ---
=IF(D2<=200,0,IF(D2<=500,7.5,12.5))
On May 12, 8:21 pm, Rajesh K R wrote:
> Hi Experts,
> Pls find the attached file and solve the issue regarding if function.
>
> Regards
> Rajesh kainikkara
>
> If function .xls
> 18KViewDownload
--
On Thu, May 12, 2011 at 8:21 AM, Rajesh K R wrote:
> Hi Experts,
> Pls find the attached file and solve the issue regarding if function.
>
> Regards
> Rajesh kainikkara
>
> --
>
> --
> Some important links for excel us
Hi Rajesh,
I am not clear with you problem, yes u can use "And" function for multiple
criteria.
for example
=IF(AND(B4=1212,C4=1117),E4,G4)
the content in yellow are the two conditions
thanks
On Thu, May 12, 2011 at 8:51 PM, Rajesh K R
wrote:
> Hi Experts,
> Pls find the attached file and solv
another variant
=DATE("20"&RIGHT(B2,2),MID(TEXT(B2,"00"),3,2),LEFT(TEXT(B2,"00"),2))
On Thu, May 12, 2011 at 8:58 PM, GoldenLance wrote:
> Use this in E2 and drag down
>
> =DATE(2000+RIGHT(B2,2),LEFT(RIGHT(B2,4),2),LEFT(B2,LEN(B2)-4))
>
> On May 12, 5:14 pm, Prabhu wrote:
> > Hi frien
Hi Experts,
Pls find the attached file and solve the issue regarding if function.
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twit
Use this in E2 and drag down
=DATE(2000+RIGHT(B2,2),LEFT(RIGHT(B2,4),2),LEFT(B2,LEN(B2)-4))
On May 12, 5:14 pm, Prabhu wrote:
> Hi friends,
>
> Plz help to change date format when downloaded report from 1st of every
> month to 9th of the month will be like DMMYY .
>
> I have no issue in changing
Hi Mahesh,
firslty thanks for your great favour it is working fine but some times it
happen to ask the path2 name
i created one folder with dump and created one sub folder as Working
then i placed the Before After Entry sheets dump.xls , Global Company Code
List .xls in both dump folder and sub
Hi,
Thank you everybody send reply, all are perfect answers.
Regards
Rajesh kainikkara
On 5/11/11, ChilExcel wrote:
> Please see attached file
>
>
>
> By Chilexcel
>
> 2011/5/10 Rajesh K R
>
>> Hi Experts
>> Pls check the attached file and tell me how to consolidate date month
>> wise.
>>
>>
Hi guys is there anyway to format a pivot table and it´s stays that way
whether i insert or take the options from and columns labels and row labels
because when i change the design of the pivot it put´s everything back to
standard like Sum of Jan instead of Jan like i what
i tried to do with a mac
I have got following data in excel. I need to copy 1st number in given
row for e.g. 122532 should be copied against 100 for 4 times & similar
way 321654 should be get copied against 200 for 3 time like way.
( Problem is that I'm not sure how many times 100 or 200 nos. comes )
kindly suggest me mac
Hi friends,
Plz help to change date format when downloaded report from 1st of every
month to 9th of the month will be like DMMYY .
I have no issue in changing the format using text to column from 10th date
because it will be in DDMMYY.
I have attached the sample sheet for your reference.Plz
hi to all thanks in advance here iam attaching one file i need like
that but idont know how to do this can u help me any one Pl
thanks & regards
On 12 May 2011 05:58, wrote:
> Today's Topic Summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
> Please help to ma
pfa
On Thu, May 12, 2011 at 12:31 AM, Mahesh parab wrote:
> Hi
>
> check whether attach file helps.
>
> On Wed, May 11, 2011 at 3:51 PM, karan 1237 wrote:
>
>> Respected Sirs/Mam,
>>
>> I need your help making my project good. Please find attachment. I will
>> be very obliged if someone can
I think Ashish is right use this,
Still try with this
"mmm'"
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mr excel
Sent: Wednesday, May 11, 2011 8:37 PM
To: excel-macros@googlegroup
Hi Karan,
Use this formula,
=OFFSET(IF($A$2="Administration, Business and Office Work",'Administration,
Business and Of'!A1,IF($A$2="Building and Construction",'Building and
Construction'!B1,'Catering and Hospitality'!A1)),'Building and
Construction'!$I$2,0)
And copy in all your gray cells
R
17 matches
Mail list logo
