• 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.

Help with excel if statement

D

Davidrsi

New Member
I have a spreadsheet that has the following formula =IF(A18="","",IF(A18<D17,+D17+C18*7,IF(D17<A18,+A18+C18*7)))

A is the date the infraction happened C= the amount of weeks of penalty D= the previous infraction date this works if the date of the infraction is as so d17=10/06/14 and in A18 we put 8/4/14 and the late day he/she loses 2 more weeks which is C18 so it would come back with a date 10/20/14 now the problem if a person was late on 8/4/14 same kind of formula it should bring back a date of 8/11/14 start of a pay period and so on I up loaded a file to show how the entire spreadsheet look like
 
Hi David ,

Can you upload your spreadsheet itself , instead of an image or picture showing what your data layout is like ?

Narayan
 
The main page is fine where i want the information to go is in column D of each driver Both of the formulas work but they won't work together that is my problem go to driver Corwyn Brown formula works fine go to Fred Heizmann the formula works but it enters the wrong date what I am trying to do is use is two different formulas in one if I enter this Formula in Fred D19 column comes up to the wrong date with A column 8/2/14 but if you enter 8/2/14 in A20 the formula works I need both formulas to work together if possible
 

Attachments

Just wanted you to know i got it to work using this code =IF(A19="","",IF(A19<D18,+D18+C19*7,IF(A19>D18,INT((A19+12)/14)*14+2))) but now i have another problem if so say the driver was penalized 4 weeks if cell A19 is a larger date then D18 it won't calulate but other than that it works
 
You must log in or register to reply here.
Back
Top