nested if(and) - aka case when - in excel

[akswartz85]

Hi all,

I'm looking for help translating a case when to excel

I want to say something like (sorry for the funky formatting, mr excel doesn't like this statement for some reason!):

<ladder 1)="" then="" "down"="" else="" "no="" change"="" end
<ladder 1)="" then="" "down"="" else="" "no="" change"="" end

<ladder 1)="" then="" 'down'="" else="" 'no="" change'="" end

case

when id = id, date2>date1, ladder2>ladder1 then up

when id= id, date 2>date1, ladder2<ladder1 then="" down=""
< ladder 1 then down

else no change
end

<ladder 1)="" then="" "down"="" else="" "no="" change"="" end

but I'm not quite sure how to do that in excel

Here's what I have for a singulars:
<ladder1),"down","other")
<ladder1),"down","other")

IF(AND(id=id,date2>date1,ladder2=ladder1),"No Change","Other")

IF(AND(id=id,date2>date1,ladder2>ladder2),"Up","Other")<ladder1),"down","other")

IF(AND(id=id,date2>date1,ladder2>ladder1),"Down","Other")

How do I combine them together? Thanks!</ladder1),"down","other")
</ladder1),"down","other")
</ladder1),"down","other")
</ladder></ladder1></ladder></ladder></ladder>

 

[Joe4]

Assuming that you are trying to do this in an Excel formula (and not VBA), then maybe this:

=IF(AND(id=id,date2>date1),IF(ladder2=ladder1,"No Change",IF(ladder2>ladder1,"Up","Down")),"Other")