2 IF statements in same cell

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

Guest

Is it possible to have 2 IF statements in the same cell?

Thanks,
Carla Bradley
carla.bradley(at)lgeenergy.com
 
Hi Carla

yes, if they're related
e.g.
=IF(A1="cat","meow",IF(A1="dog","woof","unknown animal"))

hope this helps
Cheers
JulieD
 
You can nest them up to 7 deep. If you find yourself wanting to do more
than about 3 deep then there is usually a better approach.
 
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

2 IF statements in same cell? 2
How to make repeating rows stop 2
Percentage of filled cells 1
Help please! 3
Generate list based on number 1
If statement for a range of cells 3
Multiple if statements 5
(month) 2 digits in formula 5

Back
Top