respected sir,

need your further assitance on this same fomula i have another question on
same formula i.e. =MAX((C4-D4) + MAX(C4-2*D4,0) + 2*MAX(C4-3*D4,0),0)*E4*80
now i want to change this formula like but when i m changing the charge
value its will not giving me the correct result OR not working properly
now my question is like this
charges per day of 1 LAP is 160 (from day 1st to 5th day)
2nd LAP is per day 320 (from day 6th to 10th days)
3rd slap is per day 640 ( from day 11 to ownworld for example 999)

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

A4=10-JAN-2009
B4=28-JAN-2009
C4=19
D4=4
E4=1
F4=should be 5600 instead of 6400
is it posible kindly guide me i realy thankful to you.

but if d4 is grater then or equal to 5 its is counting/working properly.
if d4 value is less then 5 its not working properly.
can you please guide where i can change




regards
Malik Nadeem


"JE McGimpsey" wrote:

In article ,
Malik Nadeem wrote:

can you please guide me from where i complete breife of MAX command

XL Help.