I am building a spreadsheet designed to keep track of employee hours. One of the things I would like to do is enter the text PTO into the cell, and have it return a numerical value of 8 for the purposes of my total hours.
Is there a way to have a formula recognize a text entry as a numerical value? I imagine it has to be part of the sum formula, telling it to treat "PTO" as though I had entered 8.
=if(A1="PTO", 8 + 100,"")
**** you cannot directly tell to read a string and tell excel to read as a value...
you can also have a table and use lookups(vlookup,index/match etc.) that can give you the correct value for each string based on the table you will create.
=sum(vlookup(),A2,A3)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks