lundi 14 janvier 2019

Google Sheets - formula for expense sheet

I need a formula that will help me calculate the $ expense amount for my milage rates.

Here is my sheet https://docs.google.com/spreadsheets/d/1PPFuFWbxWi9iIdtYBJvnSNB1j1cjjQutepF3hnpGoFM/edit?usp=sharing

On the tab that's expenses, I need to check the year of my date in Col A (because different years have different rates), then check Col D to see if it says Milage, then check Col E for what type of milage (there are 4 types), then return the number input in Col I times the appropriate rate for that year and type of milage. I have a table set up with the rates in another tab.

I'm thinking it will be a long IF and AND formula. Any help would be great!

Aucun commentaire:

Enregistrer un commentaire