Hi,
I am modifying our daily till reconciliation sheet to clearly show whether our till is up or down. This has become necessary due to errors being made…
I’ve worked out how to show this, but as you can see it then shows the rest of the week as Till Down in row 17 (or to be pedantic the rest of the week would show the most recent days resulting discrepancy). What I am aiming for is row 17 not to show anything until the till values are entered for that day.
My formula for row 17 cells is =IF(C16<0,“Till DOWN”,IF(C16>0,“Till UP”))
(Row 11 brings forward the previous days float figure to help eliminate input errors)
Is there a way to do this? I would be very grateful for any help offered.
Hopefully you can find a link to an image of my spreadsheet here: https://s5.postimg.org/55inmn2qv/Libre_Office_daily_till_reconciliation_help.jpg