Thank you very much for your consideration and the result but if I need a
formula in the same cells in which we are getting the sum of three column
without the formula, is there any possibility which shows the formula in
the three cells, because in this way we may press F2 and check the cell
re
*Greetings,*
Trust you are fine!!
My name is Angelina Williams and I am working on below position for my
client as mentioned below. Your profile is good match for this opening. I
would like to represent your contention if you think this position is match
as per your skill sets. Please read be
*Greetings,*
Trust you are fine!!
My name is Angelina Williams and I am working on below position for my
client as mentioned below. Please read below job description and let me
know your thoughts.
*Job Title: *Desktop Support Specialist
*Location: *Winston Salem, NC
*Duration: *12 + mont
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
For summing col 5,6,7 i enclose the code. verify. do it for sny no. of
sheets.the code follows:Sub sum567()
Dim LastRow As LongDim iRow As LongDim iCol As IntegerLastRow = 0
For iCol = 5 To 7 iRow = Cells(65536, iCol).End(xlUp).Row If iRow > LastRow
Then LastRow = iRowNext iCol
With Applicatio
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
