So I was putting together a fairly simple ledger in Numbers.
The formula in AppleWorks was this: IF(B3>0,E2-C3+D3,"") Which gave the result if cell B3 had a value and left the cell blank where there was no entry in B3. Still works if B3 is a positive number but fails if B3 is a date.
So how do I get Numbers to display a result if cell B3 has a date entered and return blank if there is no entry?
The formula in AppleWorks was this: IF(B3>0,E2-C3+D3,"") Which gave the result if cell B3 had a value and left the cell blank where there was no entry in B3. Still works if B3 is a positive number but fails if B3 is a date.
So how do I get Numbers to display a result if cell B3 has a date entered and return blank if there is no entry?
via ehMac.ca http://www.ehmac.ca/showthread.php?t=115033&goto=newpost
Aucun commentaire:
Enregistrer un commentaire