Thanks J
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kartik Dale
Sent: Tuesday, December 24, 2013 12:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ NEED FORMULA HELP
Hi Dhaval,
Please find attachment
Regards
YES
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaikh Iqbal
Sent: Friday, December 13, 2013 4:38 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need - formula help
Ravinder,
is it correct
=IF(B2="Platinum&qu
Ravinder,
is it correct
=IF(B2="Platinum",INT(C2/3)*1200,IF(B2="Gold",INT(C2/12000)*480,IF(B2="Silver",INT(C2/6000)*240)))
On 13 December 2013 16:25, Ravinder wrote:
> I think u r looking for this.
> =IF(B2="Platinum",INT(C2/3),IF(B2="Gold",INT(C2/12000),IF(B2="Silver",INT(C2/6000
Ravinder,
Ya its fine but slab multiply with card Platinum*1200 / Gold*480 &
Silver*240
On 13 December 2013 16:25, Ravinder wrote:
> I think u r looking for this.
> =IF(B2="Platinum",INT(C2/3),IF(B2="Gold",INT(C2/12000),IF(B2="Silver",INT(C2/6000
>
>
>
> *From:* excel-macros@googlegrou
I think u r looking for this.
=IF(B2="Platinum",INT(C2/3),IF(B2="Gold",INT(C2/12000),IF(B2="Silver",IN
T(C2/6000
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaikh Iqbal
Sent: Friday, December 13, 2013 4:07 PM
To: excel-macros@googlegroups.com
Thanks a lot Ravinder J
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Thursday, November 28, 2013 5:48 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Need formula help
=DAY(B2)
From: excel-macros
=DAY(B2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dhaval Shah ( Ahd )
Sent: Thursday, November 28, 2013 5:44 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need formula help
Want to choss Day only from date pls refer attachme
Dear Excel lerner,
use SUMPRODUCT formula to get desired result
see the attached file
--
*Kalyan Chattopadhyay*
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thre
Dear excellerner,
Use $ sign to make constant row or column .
for eg
if u select A1 A10 then write $A$1 $A$10.
first $ is for column and second $ is for row.
you can use only one $ for only one column like $A1 or you can use only one
row like a$1 .
Regards,
Gawli
On Mon, Dec 10, 2012 at 12:31 PM,
