Takeaway a value or set a value to 0 depending on text entered into another cell.

[Luke1690]

Hi,

please can someone help me with this.
i have created a holiday planner and when dates from and to are entered it auto populates the amount of days taken between the dates and shows them in a range on the same row lets say ($A3)
it then takes the days used and takes it from there total holiday allowance.

Now the manger can go into the same document and review the holidays by selecting a Accept or Reject from a drop down in ($E3)


(What I'm looking for is IF Rejected has been chosen it sets the Value of ($A3) back to Zero)

Thanks Guys

 

[Sufiyan97]

What is the current value of $A3?

Can you post some rows of sample data along with expected results?

 

[Fluff]

Maybe

Fluff.xlsm
	A	B	C	D	E
1
2	3	25/03/2023	27/03/2023
3	0	01/04/2023	07/04/2023		Rejected
Main

Cell Formulas
Range	Formula
A2:A3	A2	=IF(E2="Rejected",0,C2-B2+1)

 

[Luke1690]

Maybe

Fluff.xlsm
	A	B	C	D	E
1
2	3	25/03/2023	27/03/2023
3	0	01/04/2023	07/04/2023		Rejected
Main

Cell Formulas
Range	Formula
A2:A3	A2	=IF(E2="Rejected",0,C2-B2+1)

Sorry for the late reply this worked thanks.

 

[Fluff]

You're welcome & thanks for the feedback.