Search results

sorry but said that to add solution for the problem I removed the link regards

many thanks for all support formula solved using this =CHOOSE(MATCH(A1,{0,2001,3001,4001,5001}),2000,MIN(2250,MAX(2000,75%*A1)),MIN(2800,MAX(2250,70%*A1)),MIN(3250,MAX(2800,65%*A1)),MIN(3500,MAX(3250,60%*A1)))

thanks for this soultion but it required in formula in my project. can try vlookup or match and index

thanks for reply but I Try it =IF(S3<=2000,S3, (IF(S3<=3000,IF(S3*75/100<2000,2250,S3*75/100),(IF(S3>=4000,IF(S3*70/100<2250,S3*70/100,2800), (IF(S3<=5000,IF(S3*65/100<2800,3250,S3*65/100),(IF(S3<=5000,IF(S3*60/100<3250,3250,IF(S3*60/100>3500,3500,S3*60/100))))))))))) what the wrong with...

hi all how do this formula? if multiple condition if number less than 2000 ,2000 from 2001 to 3000 -------> result 75% with minimum 2000 and maximum 2250 from 3001 to 4000 -------> result 70% with minimum 2250 and maximum 2800 from 4001 to 5000 -------> result 65 % with minimum 2800 and...

thanks arnelgp 🥰🥰

thanks for your response CJ_London this what I want

how to calculate sum for the following per each employ if count of days more than 30 than add 1 to month than if month =12 month =0 and add 1 to years EMP EMP SumOfDAYS_NO SumOfMONTH_NO SumOfyears_No final days final month final years A A 32 11 13 2 0 14 B B 37 17 15 7...

file is excel not access

Attached Files

no other alternative many thanks again for your help

but DLookup() is said to be so with large datasets. what can use if large database

many thanks bob fitz

please ignore value 500,600,800,900 use this value Value 1120 2050 1799 1650 1120 ------ is between minimum_Value 1101 and Maximum_Value 1200 so it return category_Id 2 2050------ is between minimum_Value 2401 and 2600 so it return category_Id 8

hi I have table Categ_Tb ---> category_Id - minimum_Value - Maximum_Value AND Other table Value_Tb Value i need query Query1 LOOKUP this VALUE in minimum_Value - Maximum_Value if it between minimum_Value - Maximum_Value return category_Id

ok can repeat header in each page i have error when open report

if less than 29 record i need to complete page with same format like excel ( table ) if equal is ok i need to see the page complete ( record or blank) for example if the record equal 35 it make page 2 and the page 2 complete it with blank record

i download again same issue

no i didn't add blank lines but when i deleted some of record the page not fully formatted table as blank (( what i want )

when I deleted SOME OF RECORDS the remaining row show numbers as attached