If then formula using a date

Closed
chashare Posts 1 Registration date Monday 8 September 2014 Status Member Last seen 8 September 2014 - 8 Sep 2014 à 17:45
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 8 Sep 2014 à 19:47
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 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
8 Sep 2014 à 19:47
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