IF AND formulas
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
Comments
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!