Excel Formula

[Scouser]

e.g.
cell A1 Todays Date (Now),
cell A2 if blank no change,
If A2 has a date less than A1, then text to apear "Remove date", is this possible?

 

[Pupster]

Yes this is possible are you familiar with IF statements?

if not let me know and i will right the formula down for you.

 

[Zack Barresse]

e.g.
cell A1 Todays Date (Now),
cell A2 if blank no change,
If A2 has a date less than A1, then text to apear "Remove date", is this possible?

=if(a2<a1,"Remove date",a2)

if's go:
=if(condition to meet, if true then, if false then)

HTH

 

[Iridium]

Just so firefytr's answer displays correctly:

=if(a2<a1,"Remove date",a2)

if's go:
=if(condition to meet, if true then, if false then)

 

[Zack Barresse]

oops!

that's what i had, don't know what happened. that's a little embarassing

but thank you iridium!

 

[Iridium]

oops!

that's what i had, don't know what happened. that's a little embarassing

but thank you iridium!

Not your fault - just a feature the HTML coding of the page - that's all!

 

[Brian from Maui]

How about,

=IF(A2="","",IF(A2 < A1,"Remove date",A2))

 

[Scouser]

How about,

=IF(A2="","",IF(A2 < A1,"Remove date",A2))[Cheers brian, Is Black Max bar still open?