formula

Syndicate content

Here is an example of a formula that returns a different price for each of several kinds of fruit. The data type of the result is Number.

case ([Fruit Name], "Apples", .5, "Pears", 1, "Berries", 4)

If the [Fruit Name] doesn't match any of the cases, null is returned. To return a default value when there is no match, add one more Number argument to the end.

February 5th, 2009 - 6:02 PM

Let's assume the Date field is called "My Date" and that the Time of Day field is called "My Time of Day". Let's also assume that you want the display format to be:

08-17-2001 01:01:01

Then the text formula to display the date and the timestamp fields together in one cell would be:

[My Date] & " " &

Right("0" & Hour([My Time of Day]), 2)

& ":" &

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit