trying to combine 2 formulas base on cell value

Copper Contributor

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

1 Reply

@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