Hi!
I have created a spreadsheet at work (unfortunately cannot attach the file for security) to calculate show the type and amount of leave a person has left.
I have the total amount of annual leave days allocated in B1 (Example: 23), and on B2 the number of days the person is taking (example: 3), and the amount of days left on B3 (20). So far it is very easy.
I have created a drop down menu to select the type of leave (annual leave, sick leave, compassionate leave, etc) and I would like the value in B3 to be the result of the subtraction only if annual leave is selected from the drop down menu. At the moment it looks like all the types of leave would affect the person's allocation but it shouldn't be that way and I cannot find the function to reflect this.
If you can help that would be great!! Thanks and hope the description is clear.