Forum Discussion

juliejo's avatar
juliejo
Copper Contributor
Jan 25, 2022
Solved

Complicated IF/OR formula needed

Hello! I have a messy formula that I need to figure out. I have a list of several options. Most of them require a common formula, but two of them require unique formulas. They all use the same field ...
  • Detlef_Lewin's avatar
    Jan 25, 2022

    juliejo 

    =ROUNDUP(H55*H56+SWITCH(A55,"Option1",-400,"Option2",-500,0),0)

     

Resources