Need Excel Formula to show Increase\Decrease\Same

[Freeman2022]

Hello,

I'm trying to see what formula I could use in Column D showing if the number in Column C has increased\decreased or stayed the same from Column B

 

[Joe4]

One way using nested IF functions:

=IF(B2<C2,"Decreased",IF(B2>C2,"Increased",IF(B2=C2,"Stayed the Same","Unknown?")))

 

[etaf]

how about

=if(or(b2="",c2=""),"", if(b2=c2,"the same",if(b2>c2,"increase",if(b2<c2,"decrease","error"))))

 

[Freeman2022]

One way using nested IF functions:

=IF(B2<C2,"Decreased",IF(B2>C2,"Increased",IF(B2=C2,"Stayed the Same","Unknown?")))

This will work, thank you so much..

 

[Freeman2022]

how about

=if(or(b2="",c2=""),"", if(b2=c2,"the same",if(b2>c2,"increase",if(b2<c2,"decrease","error"))))

This actually works also, thank you

 

[etaf]

you are welcome