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 ...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jan 25, 2022

    juliejo 

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

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 25, 2022

juliejo 

=IF(A55="Option1",ROUNDUP(((H55*H56)-400),0),

IF(A55="Option2",ROUNDUP(((H55*H56)-500),0),ROUNDUP(((H55*H56)),0)))

 

This could be what you are looking for.

Resources