IF AND formulas

Dave Godfrey

I wonder if anyone would be able to help me.

 

I am trying to collate some data that allows me to give a count of a number of jobs that have missed a target date.  The sheet I am working on also has 2 different cost centres and I would like to break this data down so that I can see the data for each cost centre.  I have managed to get the IFAND formals to work for both of the sheets, an example of one is below.

=IF(AND([Purchase Order Issue Date]25 > ([Date Quote Sent to Client]25 + 29), [Purchase Order Issue Date]25 < ([Date Quote Sent to Client]25 + 46)), 2, 0)

I am struggling to add the =IF([Cost Centre]25 = 3444 part of the formula for this to work.

 

Any suggestions would be a massive help.

 

Thanks

Dave

 

Dave Godfrey

Hi Everyone,

 

I have now managed to figure this one out.

The formula should be

=IF([Cost Centre]25 = "3444", IF(AND([Purchase Order Issue Date]25 > ([Date Quote Sent to Client]25 + 29), [Purchase Order Issue Date]25 < ([Date Quote Sent to Client]25 + 46)), 2, 0)

 

Thanks to anyone who has looked at this.

 

Dave