Function Required

[Idrees Khan]

Hi all
Following is the Query
A Colum. b colum
5500 =< than 160
7100=< than 185
11050=< than 240
13450=< than 270

Please help which function is worked for above

[robleyd]

I'm not sure exactly what you are asking, but for a guess you might want VLOOKUP.

Perhaps if you can explain a little more clearly what you are trying to do, we can give better advice.

[Idrees Khan]

PAYGRADES.pdf

(29.44 KiB) Downloaded 111 times

I want if i enter value 3500 in cell A1 then it must show value 110 in cell B1 or if I will enter value 4600 in cell A1 then it must show value 150 in cell B1 and so on as given.

[Zizi64]

Hi all
Following is the Query
A Colum. b colum
5500 =< than 160
7100=< than 185
11050=< than 240
13450=< than 270

Please help which function is worked for above

You gave us incomplete information.
Please upload your real ODF type sample document here, and give us more details about your problem.

[RoryOF]

This is a very similar query to that in
viewtopic.php?f=9&t=89574

[Idrees Khan]

PAYGRADES.pdf

[robleyd]

You need the VLOOKUP function - see VLOOKUP on the OpenOffice Wiki or search VLOOKUP in the offline (F1) help.

[Lupp]

The question here looks very similar to the one posted an hour earlier (2017-07-18 08:26) by "khalid". May it be that you both are participating in the same class?

[Zizi64]

PAYGRADES.pdf

What is it?

[soby]

with so less info; we can not give a solution to your problem
but i did try to make some

[Idrees Khan]

Paygrade.pdf

Pya Grade

(11.12 KiB) Downloaded 69 times

Sorry to all I can not explain my question and Thanks Soby it help me lot, one more request to you kindly view my attachment and complete the Pay Grade tell end . Thanks.

[Zizi64]

Paygrade.pdf

The .pdf can not show us what formulas you have tried to use.
Please upload your real .ods sample here.

[Idrees Khan]

Paygrade.pdf

payunit

(14.2 KiB) Downloaded 88 times

I have 250 employees data and every employee has different basic pay . I need a function to
handle this according to the basic pay and pay Grades.
Let Suppose an Employee Basic Pay <=3500 then increase in basic Pay 110. as given in Pay Grade
in column. B and then total (Column A+ B) and pay Grade change according to basic pay.

[Zizi64]

Please upload an .ods sample file here, but NOT a .pdf one.

[Idrees Khan]

pay per units.ods

(10.76 KiB) Downloaded 103 times

please view it.

[Lupp]

The first attachement above (pay per unit) seems to contain a contradiction - as well internally as with respect to above given explanations. In short:
110 applied up to 3500?
150 only apllied if at least 5900?

An answer is not possible if the intentions are not completely clear.

[soby]

If i am wright the pay per unit was my first tough and with so less info its normal to suggest something like that.
But now i see more clear, its more a yearly upgrade of the basic payment.
So the mere years a employee works the higher the payment.
I hope this is it.

[Lupp]

(OK. I was wrong to download that file. Thought it was by the OQer. )

I now attach a reworked version of the other ods (Paygrade.ods) attached by the OQer.
Lookup tables for matching a search value like "greater than the previous entry but not greater than this one" are not directly supported. VLOOKUP and MATCH as well search a column assured to contain ascending values asking for the "index of the bottommost entry being not greater" than the search value.
For more details see attachment.

[soby]

I have made some changes at your attachment, if its a per year increase of basic pay, than after 10 years, year 11 it change from 110 to 130 increase.
Lupp's solution may also of help

[Idrees Khan]

Paygrade.ods

(13.07 KiB) Downloaded 103 times

view sheet (3)
Thank a lot SOBY this function working perfectly, there is need some changing regrading pay grade
I need 1st increase of basic pay as per grade in separate column not sum in basic.
2nd a condition required if an employee joining period not less than six month than he is not entitlement of annual increment and if greater than six month and less than 9 month than half of increment will given and if greater than 9 month full increment will given.
Make it please as I desire

[soby]

I needed some time because i didn't find a solution for the 6 to 9 month
i hope this will help

[Idrees Khan]

Yes this help, waiting for solution for 6 to 9 month please.

[soby]

yes your were right, i mist the 6 and 9 month calculation
play a bit with the date in B5 to see the changes in the increase rate column