=IF(AND(cell1700,cell<2599)cell*.25,0)

in Excel, no idea about Works

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Truck driving woman" <Truck driving wrote
in message ...
How can I say "If cell value is 1700 but < 2599, then * .25 else 0"? I'm
actually working with the Microsoft Works spreadsheet, but I think the
formulas are pretty much the same. It's been so long since I messed with
this
stuff.... Thanks much