The formula currently to arrive at total revenue is Column I (deposit amount 25%) + Column O (Balance amount)
As I say, we have the following columns -
Column F - Agreed rate (Just a figure)
Column I - Deposit 25% (No sum, just 25% of agreed rate)
Column N - Extras cost (=K1*L1, K being number of people, L being cost)
Column O - Balance amount (=IF(P1="",-ABS(F1-I1+N1),F1-I1+N1)
Column P - Date balance received (Either the date or NA or CASH)
Column Q - Total revenue (=I1+O1)
Basically the way it is working at the moment, is the balance amount is negative until a date is in place, but the total revenue can also appear negative as it takes into account any deposit taken and adds the balance amount (Which could be negative if a date hasn't been added)
This then gives a false running turnover total for the year.
What we would like is for either there to be a formula to stop this, or as I mention above, allowing Q=I+O but only adding O if there is a figure in P?
Hope that makes sense,