Previous Thread
Next Thread
Print Thread
Hop To
Need help with a Numbers formula #636211 12/26/15 01:36 PM
Joined: Jan 2010
Posts: 364
PapaBill Offline OP
Where's the cache?
OP Offline
Where's the cache?
Joined: Jan 2010
Posts: 364
In my Diabetes blood-sugar tracking spreadsheet, I have in one column the blood level, and in the adjacent column is the time. In Excel, the formula for the time is such that the time is entered 'automatically' as soon as the blood level is entered:

IF(ISBLANK(A2),"",IF(B2="",NOW(),B2))

A2 is the blood level, and B2 is the time.

My question is this: how can that formula be rewritten to something that will work in numbers?

Thanks


I can do all things through Christ which strengtheneth me. Philippians 4:13
Re: Need help with a Numbers formula [Re: PapaBill] #636249 12/27/15 06:42 PM
Joined: Apr 2002
Posts: 15,080
Reboot Offline
Muhahahaha
Offline
Muhahahaha
Joined: Apr 2002
Posts: 15,080
Did you check out any of those templates I posted for this? One was free, one was only 99.

Re: Need help with a Numbers formula [Re: Reboot] #636255 12/28/15 12:26 AM
Joined: Jan 2010
Posts: 364
PapaBill Offline OP
Where's the cache?
OP Offline
Where's the cache?
Joined: Jan 2010
Posts: 364
Yes I did, but no help


I can do all things through Christ which strengtheneth me. Philippians 4:13
Re: Need help with a Numbers formula [Re: PapaBill] #636313 12/31/15 01:17 PM
Joined: Jan 2010
Posts: 364
PapaBill Offline OP
Where's the cache?
OP Offline
Where's the cache?
Joined: Jan 2010
Posts: 364
I have the formula working, but the time changes and updates to "NOW()" instead of keeping the actual time.


I can do all things through Christ which strengtheneth me. Philippians 4:13

Moderated by  Acumowchek