Forum Discussion

kfaille's avatar
kfaille
Copper Contributor
Dec 06, 2022

trying to combine 2 formulas base on cell value

i just want one formula, can this be done?

 

IF B10=8 do this (D10*8*5<G10*7*5,(G10*7*5)-(D10*8*5))/7/5

 

but if B10=7.5 do this (D10*7.5*5<G10*7*5,(G10*7*5)-(D10*7.5*5))/7/5

Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 06, 2022

    kfaille 

    What is the function of the comma in (D10*8*5<G10*7*5,(G10*7*5)-(D10*8*5))/7/5 ?

     

    Apart from that:

     

    (D10*B10*5<G10*7*5,(G10*7*5)-(D10*B10*5))/7/5

Resources