on the formulas tab, in the function library group, click the logical button, select IF from the list. enter B27>=250000 in the logical test box. enter 25000 in the value if true box, and 1000 in the value if false box. click ok