Please help. I am preparing cap sheets for my fantasy hockey league and I am running into a problem.
This is what the spreadsheet looks like:
In all of the years to the right of 2012-2013, I have the following: =IF((C9=" ")," ",IF((C9=1)," ",IF((C9>1),(C9-1))))
As you can see, the total cap hit for years after this year is not calculating. I'd rather not display a 0 in all the cells where this is no contract, but is that the only way to avoid this?? I assume it is having a problem adding the years in future years because of the blank cells?