Excel Formula (IF Function)

[Glenn Robertson]

Hi hope someone can help,

I have a spreadsheet with 3 main columns.

Column A = Run Date (format dd/mm/yyyy)
Column B = Run Processed (format dd/mm/yyyy)
Column C = Days on Target (Number)

Currently I have told Column C that if you minus Column B
from Column A it tells you in Column C how many days early
or late the run was by putting either a plus number or a
minus number.

At the moment if there is a date in Column A but no date
in column B column C gives me a ridiculous amount of -
34562. Is there any way I can put a formula in Column C
that will take away column B from column A but if there is
no info in column B it will put 0 in column C.

Many Thanks
Glenn Robertson

 

[Mark Graesser]

=IF(B1="","",A1-B1

Good Luck
Mark Graesse
(e-mail address removed)

 

[Gord Dibben]

Glenn

=IF(A1-B1<0,0,A1-B1)

Gord Dibben XL2002