Same thing, but would this idea work?

=MAX(80*A1, 160*A1-400,320*A1-2000)

5 - 400
25 - 6000

= = =
Dana DeLouis


Malik Nadeem wrote:
yes sir you are right
the correct result against 25 days will be 6000 omsetead of 7600
now below formula is workable for me and its a great help also
can you please guide me from where i complete breife of MAX command

once against thankful to you for this support and help

regards
Malik Nadeem


"JE McGimpsey" wrote:

OK, I think

=MAX((B1-C1) + MAX(B1-2*C1,0) + 2*MAX(B1-3*C1,0),0)*D1*80

may be close to what you're looking for.

I'm probably still confused, though. You say:

1st 5 days $400(80+80+80+80+80) after that 5 days (160+160+160+160+160)
after that (320+320+320.......15 times) =7600
But

5*80 + 5*160 + 15*320 = 6000

I don't see how you got 7600...

What am I missing?






In article ,
Malik Nadeem wrote:

no sir,