getting % for 2 different dates

[mwvirk]

I am using this formula to find the 0.13% rate.
=(J1*0.13%)*100
but there is a change in the policy where the rate is increased from 0.13% to 0.15% starting from 01-July-2024
Now I want to make a slight change in the formula that it should calculate 0.13% for all the previous entries but if a date is equal and above 01-July-2024 in cell F1, it should calculate it as 0.15% rate.
Kindly assist.
Thank you

 

[arun_eagertolearn]

Assuming date is in F1, please put date 01-Jul-2024 in cell F2 (or any other cell)

=if(F1>=$F$2,J1*0.15%*100, J1*0.13%*100)
(please change F2 according to where you put 01-Jul-2024)

 

[mwvirk]

Assuming date is in F1, please put date 01-Jul-2024 in cell F2 (or any other cell)

=if(F1>=$F$2,J1*0.15%*100, J1*0.13%*100)
(please change F2 according to where you put 01-Jul-2024)

=IF(F2>=DATE(2024,7,1),J2*0.15%*100,J2*0.13%*100)

thank you for the hint. i don't want to hardcode any fixed date so i used this and I hope it's working fine.

 

[MARK858]

. i don't want to hardcode any fixed date

DATE(2024,7,1) is a fixed date?

 

[mwvirk]

DATE(2024,7,1) is a fixed date?

each record is having a buying date in same row
but the IR increased from 2024-07-01
so I am checking if buying date is above 2024-07-01 then calculate new rates otherwise use the old rates

 

[MARK858]

I understand what you are doing but you stated

i don't want to hardcode any fixed date so i used this

I assume by your last post that you meant that you do want to hardcode the date rather than you don't as you stated above, in which case the formula is fine