Nested If with And

  • Thread starter Thread starter TheLeafs
  • Start date Start date
T

TheLeafs

Good day,

I am looking for assistance in creating an excel formula. I have
attempted many different variations of it, but nothing worked.
Basically, I am trying to accomplish this:

The user will enter a value in a cell (B2)

If that value is greater than the value in cell C10 place the word
"Above"
If that value is lower than the value in cell C11 place the word
"Below"
If that value is between cell C10 and C11 place the work "Ok"
If that value is " ", put "" in the cell

Any help would be great.

Thanks
 
TheLeafs,

=IF(B2="","",IF(B2>C10,"Above",IF(B2<C11,"Below","OK")))

HTH,
Bernie
MS Excel MVP
 
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

Need a function 1
nested IF statements 3
IF function, nested with 2 source cells? 5
Help with Address(), Indirect(), Offset 2
Summing values, x rows deep, depending on a criterion 2
If statements 2
Sumproduct + Array Function? 4
#name error 3

Back
Top