[QUOTE=JonSeeger;2485298]I now have that formula working correctly but now is shows the #DIV/0 message in the cell since the spreadsheet is blank. How do i get that from now showing and either show a zero or nothing at all?[/QUOTE]Showing either the value or an empty string:
Showing either the value or zero:
Depending on your locale (country), you may have to use commas instead of semicolons - I’m not sure.