Hi,
I've been scouring through a lot of tutorial videos but that's just leaving me more confused on how to proceed. I know what I want to do, but I don't know what function/formulas I need to achieve my solution, could you help me out by guiding me to the correct formulae?
My sheet:
https://docs.google.com/spreadsheets/d/1FRP0FTDhoeJU0Q-4GxR06nYv2NY6xyo6KoZoP81ARHA/edit?usp=sharing
I need to create formulae for Columns E and G.
Under my table, I've made some notes and what I need to do.
I've been scouring through a lot of tutorial videos but that's just leaving me more confused on how to proceed. I know what I want to do, but I don't know what function/formulas I need to achieve my solution, could you help me out by guiding me to the correct formulae?
My sheet:
https://docs.google.com/spreadsheets/d/1FRP0FTDhoeJU0Q-4GxR06nYv2NY6xyo6KoZoP81ARHA/edit?usp=sharing
I need to create formulae for Columns E and G.
Under my table, I've made some notes and what I need to do.