View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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