It work only 7 thousand I Need to 50,0000

[Muhammad Asim]

=IF(C7*H9<1001,"1",IF(C7*H9<2001,"2",IF(C7*H9<3001,"3",IF(C7*H9<4001,"4",IF(C7*H9<4001,"4",IF(C7*H9<5001,"5",IF(C7*H9<6001,"6",IF(C7*H9<7001,"7"))))))))

It work only 7 thousand
I Need to 50,0000

 

[eibi]

Try this:

=ROUNDUP((C7*H9)/1000,0)

It should work up to infinity...or somewhere close...Definitely past 50,000.

If you want it to stop at 50,000 -- just put it in an if statement:

=IF(C7*H9<=50000,ROUNDUP((C7*H9)/1000,0))

Helpful?

 

[Somendra Misra]

Hi Asim,

Just another formula: check as per your requirement.

=LOOKUP(C7*H9,((ROW(1:50)-1)*1000)+1,ROW(1:50))

Regards,