2 IF statements in same cell

C

Carla Bradley

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

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

JulieD

Hi Carla

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

hope this helps
Cheers
JulieD
 
J

Jack Schitt

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.
 
Top