Forum Discussion

gandriol's avatar
gandriol
Copper Contributor
May 30, 2022
Solved

Funtion IF

Hello, I have a question about the IF function I need to program a cell with this conditioning IF((J13<=15);(I13*J13);(I13*15). Note that i want to limit the factor in 15. I want that this co...
excel
Formulas and Functions
Office Scripts
  • Judit950's avatar
    Judit950
    May 30, 2022

    gandriol Hope all is well!  This might help: 

     

    =iF(H14<>"unjustified",0,if(J13<=15,I13*J13,I13*15)).  Hopefully this helps but let me know if I have misunderstood anything.