Stop random numbers when Calculating, if field is blank

MBML

New Member
Joined
Aug 7, 2004
Messages
12
Hi
I have two columns A1 and B1. A1 I can enter a date into the other one has a formula that calculates and enter the new date for example =A1+20. If A1 is blank however how can I stop the B2 column with the formula in from showing a random date
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello, MBLM,

you posted in the wrong forum
this thread will probably be moved to Excel-forum

do you need something like
=IF(A="","",A1+20)

kind regards,
Erik
 

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,640
Members
412,334
Latest member
ExcelForLifeDontHate
Top