Try it like this:

=IF(AND(B269,B5<1),1,B5)

--
Biff
Microsoft Excel MVP


"mellermj" wrote in message
...
I have two fields that I have to look at and based on those fields either
apply a specific number or have it equal the calculation in another
fields.

Age (b2)
SCr (b5)

=IF(B269 AND B5<1, 1, B5)

That doesn't work. Any advise or help would be appreciated.