Hello,
I am trying to create a spreadsheet to keep track of my business. On one sheet I have all the tables, like Class -personal, business, and split and in another all the expense categories, next Percentage to split. On the data entry sheet I have dropdown menu for class and category, and of course total$, $total from personal, $total from business, and formula to multiply by the percentage from the main sheet.
But my question is, if "split" is selected from drop down menu, and the expense category selected from drop down doesn't have a split percentage, can it alert me to change the "class" to something other than split because the percentage cell is blank or zero?
or is there a condition I can use, if I select the "split" then only show expense categories that have a percentage next to it? or if "split" is selected and "expense category" is selected that the percentage says 0, then don't let me enter total?
I am so lost. My formula works well if it has a number in percentage cell but it doesn't do anything if its 0 or blank
I am trying to create a spreadsheet to keep track of my business. On one sheet I have all the tables, like Class -personal, business, and split and in another all the expense categories, next Percentage to split. On the data entry sheet I have dropdown menu for class and category, and of course total$, $total from personal, $total from business, and formula to multiply by the percentage from the main sheet.
But my question is, if "split" is selected from drop down menu, and the expense category selected from drop down doesn't have a split percentage, can it alert me to change the "class" to something other than split because the percentage cell is blank or zero?
or is there a condition I can use, if I select the "split" then only show expense categories that have a percentage next to it? or if "split" is selected and "expense category" is selected that the percentage says 0, then don't let me enter total?
I am so lost. My formula works well if it has a number in percentage cell but it doesn't do anything if its 0 or blank