mardi 8 décembre 2015

Excel : If statment with 3 arguments

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