• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If formula with day

P

pencari

New Member
Thanks before for this great forum and all the member that willing to help us that cant solve problem at excel

i am need help with if data with day

i am trying to input at the input(coloumn F)

if i input at thevalue, in the (F coloum) the next 3 day the use (Coulum G must be blank) and at sunday all the G Coulum Blank
this is true
Code: 
Mon    8/29/2016    100    100.00      55.00      40.00      5.00    No
Tue    8/30/2016        40.00      22.00      16.00      7.00    No
Wed    8/31/2016        16.00      8.80      6.40      7.80    No
Thu    9/1/2016        -        -        6.40      7.80    No
Fri    9/2/2016        6.40      3.52      2.56      8.12    No
Sat    9/3/2016        2.56      1.41      1.02      8.25    No
Sun    9/4/2016        -        -        1.02      8.25    No
Mon    9/5/2016        1.02      0.56      0.41      8.30    No
Tue    9/6/2016        0.41      0.23      0.16      8.32    No
Wed    9/7/2016        0.16      0.09      0.07      8.33    No
Thu    9/8/2016        0.07      0.04      0.03      8.33    No
Fri    9/9/2016        0.03      0.01      0.01      8.33    No
Sat    9/10/2016        0.01      0.01      0.00      8.33    No
Sun    9/11/2016        -        -        0.00      8.33    No


this is true
Code: 
Mon    8/29/2016    100    100.00      55.00      40.00      5.00
Tue    8/30/2016    100    140.00      77.00      56.00      12.00
Wed    8/31/2016        56.00      30.80      22.40      14.80
Thu    9/1/2016        22.40      12.32      8.96      15.92
Fri    9/2/2016        -        -        8.96      15.92
Sat    9/3/2016        8.96      4.93      3.58      16.37
Sun    9/4/2016        -        -        3.58      16.37

this is the wrong,
Code: 
Tue    8/30/2016        -        -        -        -      No
Wed    8/31/2016        -        -        -        -      No
Thu    9/1/2016        -        -        -        -      No
Fri    9/2/2016    100    100.00      55.00      40.00      5.00    No
Sat    9/3/2016        40.00      22.00      16.00      7.00    No
Sun    9/4/2016        -        -        16.00      7.00    No
Mon    9/5/2016        -        -        16.00      7.00    No
Tue    9/6/2016        16.00      8.80      6.40      7.80    No
Wed    9/7/2016        6.40      3.52      2.56      8.12    No
Thu    9/8/2016        2.56      1.41      1.02      8.25    No
Fri    9/9/2016        1.02      0.56      0.41      8.30    No
Sat    9/10/2016        0.41      0.23      0.16      8.32    No
Sun    9/11/2016        -        -        0.16      8.32    No


i can create that with my formula, but when i comes to friday and Saturday, my Formula doesnt work properly

i am attach the excel,, sorry for my terible english


thx for the help
 

Attachments

  • asdasd.xlsx
    21.7 KB · Views: 5
Little confused with your query, can you please upload the desired output

pencari said:
Thanks before for this great forum and all the member that willing to help us that cant solve problem at excel

i am need help with if data with day

i am trying to input at the input(coloumn F)

if i input at thevalue, in the (F coloum) the next 3 day the use (Coulum G must be blank) and at sunday all the G Coulum Blank
this is true
Code: 
Mon    8/29/2016    100    100.00      55.00      40.00      5.00    No
Tue    8/30/2016        40.00      22.00      16.00      7.00    No
Wed    8/31/2016        16.00      8.80      6.40      7.80    No
Thu    9/1/2016        -        -        6.40      7.80    No
Fri    9/2/2016        6.40      3.52      2.56      8.12    No
Sat    9/3/2016        2.56      1.41      1.02      8.25    No
Sun    9/4/2016        -        -        1.02      8.25    No
Mon    9/5/2016        1.02      0.56      0.41      8.30    No
Tue    9/6/2016        0.41      0.23      0.16      8.32    No
Wed    9/7/2016        0.16      0.09      0.07      8.33    No
Thu    9/8/2016        0.07      0.04      0.03      8.33    No
Fri    9/9/2016        0.03      0.01      0.01      8.33    No
Sat    9/10/2016        0.01      0.01      0.00      8.33    No
Sun    9/11/2016        -        -        0.00      8.33    No


this is true
Code: 
Mon    8/29/2016    100    100.00      55.00      40.00      5.00
Tue    8/30/2016    100    140.00      77.00      56.00      12.00
Wed    8/31/2016        56.00      30.80      22.40      14.80
Thu    9/1/2016        22.40      12.32      8.96      15.92
Fri    9/2/2016        -        -        8.96      15.92
Sat    9/3/2016        8.96      4.93      3.58      16.37
Sun    9/4/2016        -        -        3.58      16.37

this is the wrong,
Code: 
Tue    8/30/2016        -        -        -        -      No
Wed    8/31/2016        -        -        -        -      No
Thu    9/1/2016        -        -        -        -      No
Fri    9/2/2016    100    100.00      55.00      40.00      5.00    No
Sat    9/3/2016        40.00      22.00      16.00      7.00    No
Sun    9/4/2016        -        -        16.00      7.00    No
Mon    9/5/2016        -        -        16.00      7.00    No
Tue    9/6/2016        16.00      8.80      6.40      7.80    No
Wed    9/7/2016        6.40      3.52      2.56      8.12    No
Thu    9/8/2016        2.56      1.41      1.02      8.25    No
Fri    9/9/2016        1.02      0.56      0.41      8.30    No
Sat    9/10/2016        0.41      0.23      0.16      8.32    No
Sun    9/11/2016        -        -        0.16      8.32    No


i can create that with my formula, but when i comes to friday and Saturday, my Formula doesnt work properly

i am attach the excel,, sorry for my terible english


thx for the help
Click to expand...
 
xlstime said:
Little confused with your query, can you please upload the desired output
Click to expand...
thanks for the help sir

i am uploading a new file

hope u understand sir,

i am tryng choose function and its the same result
 

Attachments

  • asdasd.xlsx
    36.6 KB · Views: 7
Last edited:
Hi ,

From what I can understand , column F has the value 100 on different dates.

From the last date on which the cell in column F has 100 , that day and the following 2 days will have values in columns G and H. The next day will have blanks in columns G and H.

Additionally , if the day is a Sunday , columns G and H will be blank.

Narayan
 
NARAYANK991 said:
Hi ,

See if this is OK.

Narayan
Click to expand...


hi, thx for the help Narayan , its not what i mean, by the way, i have found a way to do what i want,


sorry for my terible english...


From the last date on which the cell in column F has value(number) , that day and the following 2 days will have values in columns G and H.

if i input at the F7 column at monday, the thrusday Columns G10 and H10 will be blank, and if i input again in the tuesday F8, the Friday at Columns G11 and H11 will be blank but the columns at g10 and h10 will have a value , and so on
the problem occur when it get to friday because the sunday must have 0 value
but i have managed now with this if formula




if u have another way, please fell free to reply

thx man
 

Attachments

  • asdasd.xlsx
    13 KB · Views: 4
You must log in or register to reply here.
Back
Top