Previous Topic Next Topic

Formula

Solved/Closed
ehmetcalf Posts 2 Registration date Thursday April 6, 2017 Status Member Last seen April 6, 2017 - Apr 6, 2017 at 11:35 AM
ehmetcalf Posts 2 Registration date Thursday April 6, 2017 Status Member Last seen April 6, 2017 - Apr 6, 2017 at 12:33 PM
I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day.

I have a column with maturity dates, I have a column I want to show Matured. So if the date is today or less than it should show matured in the column or be blank.

=IF(G3<="TODAY","MATURED","")
=IF(G3>="TODAY","","MATURED")

Everything shows up Matured. Thanks for any help you can give me.

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 6, 2017 at 12:10 PM
ehmetcalf, Good morning.

The "today" function of excel must be written as TODAY() without the apostrophes.
Only that.

Try to use:

=IF(G3<=TODAY(),"MATURED","")

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
ehmetcalf Posts 2 Registration date Thursday April 6, 2017 Status Member Last seen April 6, 2017
Apr 6, 2017 at 12:33 PM
Thank you, that worked
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
Use of '@' in formulae
Quarterp -
Quarterp -

6 responses