Q: Nested if

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
Is it possible to create a nested if statment in excel?
Thanks,
Jim.
 
You can create a nested IF formula. For example:

=IF(A2>5,0,IF(B2>10,0,C2))

or

=IF(A2>5,IF(B2>10,0,C2),0)
 
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

If Statement Nesting? 4
Bargain Nest Mini (2nd Gen) - Chalk 0
Nest Guard has hidden microphone 2
Nest vs Hive? 10
NESTED OR FORMULAS 5
nested IF without repeating the condition to be tested 6
Need help with vlookup nested function 4
Limits on nested formulas 15

Back
Top