if conditional formula required
One way:
=MAX((C4-D4) + MAX(C4-D4-5,0) + 2*MAX(C4-D4-10,0),0)*E4*160
In article ,
Malik Nadeem wrote:
how to change above fumula when i m using below it is not working
=MAX((C4-D4) + MAX(C4-2*D4,0) + 2*MAX(C4-3*D4,0),0)*E4*160
|