Excel can be difficult and confusion when you know you want to do something and you just need to figure out how to do it.
I was tasked to create a spreadsheet for time management between our multiple grants. As such, there would be multiple sets of data to go through. Now, if we typed a task under Grant 1 we wanted it to auto tabulate 12 minutes. If nothing was entered, then 0 minutes.
I found several functions that were close but not quite. What I wanted was an IF function that was basically: if I type text in, then 12, if not, then 0. After a couple of hours of searching I finally was able to create my own.
=IF(ISTEXT(cell number you want to "test"), 12, 0)
This reads: if there is text in "test" cell, then auto fill 12, if not, 0.
I hope this helps someone!
