EXCEL - alternative to IF/THEN ??

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Yankee Rose

Thread Starter
Joined
Jul 14, 1999
Messages
1,861
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!
 
Joined
Nov 30, 2000
Messages
436
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top