I am creating a profit and loss balance sheet, so i can change figures in the data entry area and gain the figures i need. I have used the complex IF statement which i think is correct. The trouble I am having is that the figure is a minus figure instead of a positive figure. Is there anyway i can revert this.
If the company has a net profit of a minus then they will take an overdraft. If the net profit is less than £-5000 then an overdraft will be taken at 15% if the company has a net profit than is less than 0 but more than -5000 then they will only get charged 3%.
The overdraft is in place, however how am i supposed to make the overdraft figure a positive instead of negative? Please see the attached document, the error lays in the yellow coloured cells.
thanks
Bookmarks