Check the cost are on the desired quarter

1. Check the cost are on the desired quarter

In a spreadsheet I have a desired cost programme - ie the cost has to be spent in that given period.

And detailed breakdown of the cost.

How do I ensure check that the cost are always within required quarter.

In the attached, the cost for row 25 starts on Jun-21 quarter and but should be one quarter before that based on the value of E25 (As this is error on some formula say in A25 like if cost start and finish within the quarter then True else false)

Also, the value on row 23, should finish on the Mar-21 quarter (based on the value of E18) but finishes one quarter late.

2. Re: Check the cost are on the desired quarter

You were not hugely clear about what you wanted, but try 2 formulae, like this one:

=IFERROR(CHOOSE(SIGN(MATCH(E25,\$H\$9:\$P\$9,1)+1-MATCH(TRUE,INDEX((\$H25:\$P25>0),0),0))+2,"Late","On Time","Early"),"")

See the sheet for context.

3. Re: Check the cost are on the desired quarter

That does the job Glen

Thanks a lot

4. Re: Check the cost are on the desired quarter

You're welcome.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1