checking the date to change the result

[mwvirk]

in this existing formula in cell D1, I want to check if the date in A1 is equal to or higher than 01-July-2023 then deduct 10% from the answer
e.g. if B1 is a value of 100 and C1 is 10% then calculate B1*C1 and the result will be 10 in D1
from this result (10) in D1, I want to deduct 10% of D1 if the date in A1 is equal to or higher than 01-July-2023 so the result will be 9

my existing formula is: =IF(AND(B1<>"",C1<>""),B1*C1,"") where I am checking if the cell value is not "" and I also want to keep this exciting setting.

MWVirk PSX Portfolio v0004.xlsx
	A	B	C	D
1	1-Jul-2023	100	10%	10
Sheet1

Cell Formulas
Range	Formula
D1	D1	=IF(AND(B1<>"",C1<>""),B1*C1,"")

 

[Phuoc]

Try this:

=IF(AND(B1<>"",C1<>""),B1*C1*IF(A1>=DATE(2023,7,1),0.9,1),"")

 

[mwvirk]

perfect.
1 small concern if this can be answered.
if the result is higher than 10.50 then it returns the answer 11
I want to get the result 10 only no matter what the amount is after decimal. e.g. even if the amount is 10.10 or 10.20 or 10.50 or 10.55 or 10.90
in all cases, I want the result to be 10

I was trying the check the results in this small sheet:

Book1
	A	B	C	D	E
1	11-Jun-2024	100	12%	11
2					10.80
Sheet1

Cell Formulas
Range	Formula
D1	D1	=IF(AND(B1<>"",C1<>""),B1*C1*IF(A1>=DATE(2023,7,1),0.9,1),"")
E2	E2	=IF(AND(B1<>"",C1<>""),B1*C1*IF(A1>=DATE(2023,7,1),0.9,1),"")

 

[Phuoc]

=IF( AND (B1<>" ",C1<>""),TRUNC(B1*C1*IF(A1>= DATE(2023,7,1),0.9,1)) ,"")

 

[mwvirk]

please check this. results is 10 but still showing 9

Book1
	A	B	C	D	E
1	11-Jun-2024	100	11.11%	9
2					10.00
Sheet1

Cell Formulas
Range	Formula
D1	D1	=IF(AND(B1<>" ",C1<>""),TRUNC(B1*C1*IF(A1>= DATE(2023,7,1),0.9,1)),"")
E2	E2	=IF(AND(B1<>"",C1<>""),B1*C1*IF(A1>=DATE(2023,7,1),0.9,1),"")