Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
1,861 Posts
Discussion Starter · #1 ·
Hi. I am planning to buy a Palm M505 in order to use it with an Excel spreadsheet I've created. The only problem is, the software that comes with the Palm (Documents To Go) doesn't support IF/THEN statements. Any alternative to this? Here is what I use it for:

=IF(G14="","",DAYS360(G14,TODAY()))

where the cell "G14" contains a date. If there is NO date in this cell then the formula will return a blank. If there is a date, then the formula will calculate the total number of days since the date in cell G14. (If G14 were 11/11/01, then the contents of the cell would be 1).

I'd appreciate it if there was some way around this using an alternative function so I could use it on my Palm.

THANKS!
 

·
Registered
Joined
·
436 Posts
Umm, I'm not too familiar with that software, but I use somewhat the same idea only using this formula (only it won't be blank). I'll check on that part, but you get rid of the if/then. Hope that helps a little.

=TODAY()-G14

Drew
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top