Adding to an existing formula !!!!!!!!!

**hlb129** · 02-05-2015, 08:30 AM

I need to add something to this formula to return a blank cell. The formula is for a over 30 days old "Yes" if under 30 days old "No" but when the referenced date cell is blank the formula cell shows "yes".

IF(TODAY()-$B14>=30,"YES",IF(TODAY()-$B14<=30,"NO"))

**Sam Capricci** · 02-05-2015, 08:44 AM

you could try =IF(B14="","",if(TODAY()-$B14>=30,"YES",IF(TODAY()-$B14<=30,"NO"))) - see if it works, I didn't test it.

**AmirSoft** · 02-05-2015, 09:10 AM

=IF(B14<>"",if(TODAY()-$B14>=30,"YES",IF(TODAY()-$B14<=30,"NO")),"")
You can try this code.

**bsteady** · 02-10-2015, 08:02 AM

Hi guys. I am trying to do a similar thing with the below formula. I want it to return blank if the cell above ="specific text" if not carry on with the vlookup.

Your help is much appreciated!

=IF(A9="BARCAPV","",VLOOKUP('PLAN DATA'!B10,'C:\Templates\[Tables.xlsx]Tables'!$A$1:$F$12,4,0))