Need help

[jeff7188]

Im using 3 columns that have formulas
G has =EDATE(F3,12)
H has =G3-TODAY()
I has =IF(H3<0,"EXPIRED",IF(H3<30,"EXPIRING SOON"))

So when I put in a date in F it puts in the information I need. The problem is when I drag the formula down it shows all the information. i ONLY WANT THE INFORMATION TO SHOW WHEN I ENTER THE DATE IN COLUMN f. ANY HELP WOULD BE APPRECIATED.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(F3="","",EDATE(F3,12))

 

[etaf]

IGNORE - new message came up as I hit post
Solved
use an IF( cell you manually enter = "", "" , your formula)

 

[jeff7188]

Can you show me an example of what it would looklike

 

[jasonb75]

Then you need to check if F has a date in it as part of each formula, simply use the basics below for each of your formula columns, entering your existing formula where it says to.
Remember to remove the = sign from the start of your formula when you slot it in.

=IF(F3<>"",your formula here,"")

 

[Fluff]

Can you show me an example of what it would looklike

See post#2

 

[jasonb75]

See post#2

Or post#3, or post#5

 

[Fluff]

I suspect the OP was referring to post#3 & post#5 didn't exist when I made post#6