Thanks Abhishek,
Its working fine !
Regards,
Iqbal
On 24 May 2016 at 14:00, Abhishek Jain wrote:
> In Q2, try this:
>
> =IF(AND(P2=600,(SUM(J2:O2)<900)),(SUM(J2:O2)-600)*1.5,IF(P2=600,450,0))
>
> and drag down. Change values to test it.
>
>
> On Tue, May 24, 2016 at 12:39 PM, Shaikh Iqb
In Q2, try this:
=IF(AND(P2=600,(SUM(J2:O2)<900)),(SUM(J2:O2)-600)*1.5,IF(P2=600,450,0))
and drag down. Change values to test it.
On Tue, May 24, 2016 at 12:39 PM, Shaikh Iqbal
wrote:
> I need weekly bouns calculation, if Till Date Amount Earned = 600 then
> total daywise points from J to O c
I need weekly bouns calculation, if Till Date Amount Earned = 600 then
total daywise points from J to O column 600><900 then 300 incremental point
300*1.5=450 Max
i.g. if any one got 600, but his total daywise calculate 1000, then
900-600=300 ( 300*1.5=450 )
if any one got 600, but his total
Please explain a bit more what exactly do you need.
On Tue, May 24, 2016 at 12:09 PM, Shaikh Iqbal
wrote:
> Hi,
>
> Anybody help me !
>
>
>
> -- Forwarded message --
> From: Shaikh Iqbal
> Date: 23 May 2016 at 19:55
> Subject: $$Excel-Macros$$ Need - Formula weekly bonus
> To: e
