If then formula using a date

Closed
chashare Posts 1 Registration date Monday September 8, 2014 Status Member Last seen September 8, 2014 - Sep 8, 2014 at 05:45 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 8, 2014 at 07:47 PM
Hi, I'm trying to create a formula where if the date falls on or after 08/01/2012 the value returned is .0464 and if its before 08/01/2012 the value returned is .0769. Can anyone help?

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 8, 2014 at 07:47 PM
chashare, Good evening.

A1 --> your date to be evaluate

C1 --> Formula
=IF(A1>=DATE(2012,8,1),0.0464,0.0769)

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0