Thanx for the help i hope this will work, i appreciate it

"Executor" wrote:

Hi Mir Khan

I guess you want those figures in separate columns. Let us say Column E
up to H.
For column E: =IF(C2<6, D2, 0)
For column F: =IF(AND(C25, C2<11), D2, 0)
For column G: =IF(AND(C210, C2<16), D2, 0)
For column H: =IF(AND(C215, D2, 0)

Hoop that helps

Executor