im trying to make an IF statment with 3 arguments, this is for a spreadsheet that keeps track of my TV shows, If there's a date in the "On Break" column then that date needs to get subtracted from the current date , and if there's nothing in the "On break" colum then it has to show nothing. ( i have this working). But, now im trying to figure out if i can create another argument that lets me fill in TBA (To Be Confirmed, for tv shows that are on break but no new episode date yet confirmed) and when i fill in TBA it also has to show nothing. If i fill in TBA now i get an error. Here are some screenshots. note that i am using the dutch version of excel so IF = ALS. Screenshot of what currently have Can some1 help me with this?
Aucun commentaire:
Enregistrer un commentaire