hi
use the min fuction.
=min(a1,c5,r9,ect)
or
=min(a1:A100)
read up on it in help.

Regards
FSt1

"Shazza" wrote:

Can someone tell me how you take the figures from two different cells and put
the lesser amount into another cell so that each time they change so does the
main cell
--
Shazzanz