Forum Discussion
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
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