Forum Discussion
Help to create a sheet where if text is add/subtract to do that math
Hi, I am trying to create a sheet where you put in the date, start time and finish time, time spent, lieu hours, math (Add/Subtract) and current hours. Example Date: 15th December 2022 Sta...
Hi Mattmetes,
Oh okay, I get it now.
Excel Sheet link
https://docs.google.com/spreadsheets/d/1CILovsvM_LP1YYHZeKxRYJALzNIqn4C3/edit?usp=sharing&ouid=115216219569436501114&rtpof=true&sd=true
Hopefully you are able to understand by seeing the table.
Let me know if you have any issue's access it or editing it.
Oh okay, I get it now.
Excel Sheet link
https://docs.google.com/spreadsheets/d/1CILovsvM_LP1YYHZeKxRYJALzNIqn4C3/edit?usp=sharing&ouid=115216219569436501114&rtpof=true&sd=true
Hopefully you are able to understand by seeing the table.
Let me know if you have any issue's access it or editing it.
NO issues with accessing the Google Doc. Thank you.
But I don't understand what it is you want done. And, quite frankly, don't understand why you don't just write the formula that DOES the adding or subtracting. You clearly know how to write formulas.
But if you wish help, please describe in words, now, based on the data in the various columns of that Google Spreadsheet,
what columns you'd want to have added when the word in Column E is "Add" and
what columns would be involved in subtraction, when the word is "Subtract"
It seems as if it's the IF or IFS function that you are wanting help with....so spell out in words
IF (E3="Add",.... then (do this, in words)
IF (E4-"Subtract"...then (do this, in words)