how to tell which field has the lowest value

[Frank]

i have a form and have 2 fields in the form one is an
appraised value and the other is a sales price i want
my 3rd field to give me the one that has the lower amount
for example

appraised value $100,000
sales price $90,000
lowest $90,000

is there some way to do if logic?

 

[Allen Browne]

Answered in "dan's" identical post 10 minutes later.

 

[grep]

Uncanny, ain't it. Must be ESP or somethin'...

grep