Assume you input data in A1 and your formula in A2

Select A1
Goto DataValidation
In settings tab Allow: Custom, Formula: =A20

You may want to look at other settings and customize to suits your need.


wrote in message
ups.com...
i am trying to get a currency cell to have a minimum value of £0 (i
dont want it to go into -£)..the cell has a simple formula in it...so
i need to have the formula still....i tryed typing in MIN (0) but that
didnt work....im guessing its in some sort of properties....can any1
help

thanks