View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mellermj mellermj is offline
external usenet poster
 
Posts: 4
Default IF Statement that looks at two fields

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.