calculate the days ...

[Ambiguooous]

Hi everyone

I have a daily report showing some figures this report including one column to calculate the current percentage and there is another column shows the agreed(approved) percentage for every customer "raw".

My boss has requested from me to show in my report for those customer who breach the agreed percentage (the current percentage is greater than the agreed percentage) to show for how many days this has been breached or on other words since which day this customer is breaching the agreed percentage .. and then to be cleared if there is no breach.


I wish i could explain the idea ...

Example

[TABLE="width: 267"]
<tbody>[TR]
[TD]Agreed %[/TD]
[TD]Current %[/TD]
[TD]Breach[/TD]
[/TR]
[TR]
[TD]60%[/TD]
[TD]58%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]70%[/TD]
[TD]68%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]60%[/TD]
[TD]80%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]60%[/TD]
[TD]50%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]70%[/TD]
[TD]77%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]60%[/TD]
[TD]55%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]60%[/TD]
[TD]57%[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

https://imgur.com/a/nP6RClJ

https://ibb.co/er9nMV

 

[Ambiguooous]

???

 

[Michael M]

Maybe this, but it won't be able to show how many days, without date data
drag formula down as required

Excel 2007
	A	B	C	D
1	Agreed %	Current %	Breach
2	60%	58%	OK
Sheet2

Cell Formulas
Range	Formula
C2	=IF(B2>A2,"Breached","OK")

 

[Ambiguooous]

Maybe this, but it won't be able to show how many days, without date data
drag formula down as required
Excel 2007

	A	B	C	D

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Agreed %[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Current %[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Breach[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]60%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]58%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]OK[/TD]
[TD="align: right"][/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]C2[/TH]
[TD="align: left"]=IF(B2>A2,"Breached","OK")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you brother for this .. however what i need is "the breach duration" is there any way to know that !!!

 

[MARK858]

Thank you brother for this .. however what i need is "the breach duration" is there any way to know that !!!

As Michael has stated not with you providing no date data.

 

[Ambiguooous]

there will be today date at the top of the report (because the report is prepared on daily basis)

 

[Michael M]

Still won't work.
You will need the today date, which you say you have AND the date the data started