![]() ![]() On a side note, your AND in your formula is not currently serving any purpose as there is only 1 term inside the AND function. One thing you have not done is to test the value in G108 to see if it is a number or not as well. If its a number you are performing your math operation on it and if it is not a number to return a blank. ![]() This is great as you are testing the date in N108 to see if its a number or a string. You state in your comment that your formula is: =IF((AND(ISNUMBER(N108))), N108-G108, "") If you are on a Mac I believe the year will be slightly different. Again you can test this by entering 1 in a cell and then formatting it as date. Dates are stored as the number of days since with that date being 1. If you turn around and change the format back to general the display should be 0.5. ![]() If you enter 0.5 in a cell with general format, it will display as 0.5 However if you then change the format to Time is will display as 12:00 or what ever your local time format is set too. Excel however does convert the contents to display in a format we are more accustom to seeing.Įxcel stores dates as integers and times as decimal (or fraction of a day). Formatting a cell as Date does not make the contents a date. This is very important to note especially for dates. Formatting of cells does not control the contents of cells, it just controls the fashion in which they are displayed. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |