Excel Formula

P

Pupster

Board Regular

Joined

Nov 5, 2002

Messages

54

• Jan 30, 2004

• #2

Yes this is possible are you familiar with IF statements?

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

 

Upvote 0

Zack Barresse

MrExcel MVP

Joined

Dec 9, 2003

Messages

10,881

Office Version

1. 365
2. 2010

Platform

1. Windows
2. Mobile
3. Web

• Jan 30, 2004

• #3

Scouser said:

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?

Click to expand...

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

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

HTH

 

Upvote 0

Iridium

Well-known Member

Joined

Jul 15, 2002

Messages

2,831

• Jan 30, 2004

• #4

Just so firefytr's answer displays correctly:

Code:

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

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

 

Upvote 0

Zack Barresse

MrExcel MVP

Joined

Dec 9, 2003

Messages

10,881

Office Version

1. 365
2. 2010

Platform

1. Windows
2. Mobile
3. Web

• Jan 30, 2004

• #5

oops!

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

but thank you iridium!

 

Upvote 0

Iridium

Well-known Member

Joined

Jul 15, 2002

Messages

2,831

• Jan 30, 2004

• #6

firefytr said:

oops!

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

but thank you iridium!

Click to expand...

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

 

Upvote 0

Brian from Maui

MrExcel MVP

Joined

Feb 16, 2002

Messages

8,459

• Jan 30, 2004

• #7

How about,

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

 

Upvote 0

S

Scouser

New Member

Joined

Jan 29, 2004

Messages

3

• Jan 30, 2004

• #8

Brian from Maui said:

How about,

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

Click to expand...

 

Upvote 0