Hi,
Note: Added attachemnt to original post; I isolated the form shown in the pic and created a spreadsheet to make it easier for those helping me to try their formulas. : )
In the attached screen pic I have cells I31-K31 bordered in blue. The formula for the cells in column K is simply (for example in row 31) =J-31-I31. I have those cells set to Custom format 0;;; so that they display blank when the value is 0 or when the cell is blank, which is perfect for when there is no data in the cells (as is the case for rows 38-43). However, in the rare instances where the payoff months will be the same, as is the case for row 31, I'd like those cells to display 0 and not blank, so I need the IF formula that would meet the condition for that to take place. Any help on this would be greatly appreciated.
I was also wondering if there is a custom format that provides the same left and right cell padding as the Accounting format. So far, it seems all other formats are right up against the cell border unless you have the cell/s set to center or use the indent arrows which indent further than I would like.
Thanks
Bryan
Bookmarks