Sheets Search

I own a business that does rentals and am trying to make a spreadsheet to help artists calculate rent from their earnings. Rent is 30% of earnings with a minimum of $700 and a maximum of $1000. How can I calculate rent in a “total due” cell?

There is a table containing expenses and income (date, amount description, category - income/expense). Is there a way i can calculate budget (income-expenses) for any given month

I have a table that has Product, Total Sales and Units Sold. I want to calculate price per unit in a safe manner i.e if total units sold is 0, the output should be 'No Units Sold'