Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula that will allow me to calc before a certain date and after a certain date.
=if(A2<=DATE(2015,8,27),(F2*1.14),(F2*1.15))
It just multiplies column F with 1.15.
I'm assuming I need to bring in the date column into the equation?
Solved by M. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
15/03/2018 - 08:08
Hello, welcome to Got It pro
User
15/03/2018 - 08:08
Hello
Excelchat Expert
15/03/2018 - 08:09
Let's try it on sheet
Excelchat Expert
15/03/2018 - 08:10
I just copy your formula
Excelchat Expert
15/03/2018 - 08:11
as you see it works here. Let's think what can be missed here
User
15/03/2018 - 08:12
Let me copy my sheet
Excelchat Expert
15/03/2018 - 08:12
1.A column must be date
User
15/03/2018 - 08:12
I copied my test table.
Excelchat Expert
15/03/2018 - 08:13
2. if you compare with F2 only you have to save its place by adding dollar sign "$F$2"
User
15/03/2018 - 08:14
Why would it not work on my sheet bybut it works here?
User
15/03/2018 - 08:14
What would my date format have to be?
Excelchat Expert
15/03/2018 - 08:16
first I check the dates with isdate() formula
Excelchat Expert
15/03/2018 - 08:16
as ypu see some aren't dates
Excelchat Expert
15/03/2018 - 08:16
let's reprint them
Excelchat Expert
15/03/2018 - 08:16
17/5/2016
Excelchat Expert
15/03/2018 - 08:19
i see its american date format here
Excelchat Expert
15/03/2018 - 08:20
first day, after that -day
User
15/03/2018 - 08:20
What format should it be for the formula to work on my sheet
Excelchat Expert
15/03/2018 - 08:21
you should your data at date column be at american date format
User
15/03/2018 - 08:22
Ok I will try that. Thank you for your help
Excelchat Expert
15/03/2018 - 08:23
the formula is OK
Excelchat Expert
15/03/2018 - 08:23
as you see i change amount to 100
Excelchat Expert
15/03/2018 - 08:23
the date after is 115
Excelchat Expert
15/03/2018 - 08:24
and before is 114
Excelchat Expert
15/03/2018 - 08:24
you also can check if date is correct by =ISDATE()
Excelchat Expert
15/03/2018 - 08:25
Thank you. Have I answered your question?
Excelchat Expert
15/03/2018 - 08:25
Thank you for using Got It and welcome again
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
