Forum Discussion

Natas20075's avatar
Natas20075
Copper Contributor
Apr 30, 2019

Priority formula

Hi, I want to know if there and how we can use priority in a excel formula. I need to ask first to find the Day text in a cell from a date ex: Monday 4/15/2019, than with that name add a condition I...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 30, 2019

Natas20075 ,

 

Hi,

 

I guess everything could be done with one formula, however quite often it's worth to use helper tables/columns - easier with maintenance and you always may check intermediate results.

  • Natas20075's avatar
    Natas20075
    Copper Contributor
    Apr 30, 2019

    SergeiBaklan 

    OK thank for the answer, as I just start learning excel, I will look what that is and how to use that option. if you say that will be better and faster, then I will move that way.

     

    thank Sergei

     

Resources