IF Statement that looks at two fields

  • Thread starter Thread starter mellermj
  • Start date Start date
M

mellermj

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(B2>69 AND B5<1, 1, B5)

That doesn't work. Any advise or help would be appreciated.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Long Long Long Nested If Function 4
if statement 2
Multi-demensional frequency distribution 4
How do I create If then statements 2
If statement in excel 3
Formula to return a formula 1
IF and OR formulas 4
Using reference column # in IF Statement 4

Back
Top