slab

Dear Sir, I have a problem I want a formula for the problem Problem is: In a cell I have number of days (the days btw 2 dates) Keeping that as reference: I have 3 slabs: slab 1 : if the days are more than 5 and less than or equal 10 the number of days should display in a cell next to the slab...

Hello, I have an excel that contains total month wise time for each employee in columns. Total amount for each employee needs to be as calculated based on a slab. The slab is For 0-20 Hours: $8200 + $50 Per Hour For 21-40 Hours: $9200 + $60 Per Hour Now if a person has worked 38:55 Hours in...

I have this in cell K5: =IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR"},$G5))),"Slab","Floor Plans") I would like to combine that with this: =IF(OR(ISNUMBER(SEARCH({"Open Web"},$G5))),"Open Web","Floor Plans") I ended up with this, but it gives me a #VALUE!: =IF(OR(ISNUMBER(SEARCH({"SLAB -...

Hi I want to create a work sheet to calculate income tax a follows TAX RATE SLAB TAX YEAR 0% 0-300,000 2019 5% 300001-50000 20% 500001-1000000 30% 1000000- income 354000 Besides using if conditions is there...

Hi Friends I am trying to figure out a formula based on IF condition. My working is as attached in below link. if there are 3 or more deals in a month (column B), and total slabs (column i) are also 3 or more, than date of bonus (column L) for first, second and third slab will be same as...

Hi, How to calculate in Slab. below is example. <tbody> <tbody> Total Days Deducted </tbody> <tbody> 48 </tbody> <tbody> Already Deducted Days </tbody> <tbody> 32 </tbody> <tbody> Need to be Deduct </tbody> <tbody> 16 </tbody> </tbody> <tbody> </tbody>...

Hi All, Looking your help for constructing the formula. I have a data which looks like below . In the date field there are dates and time <tbody> Date Time spent in minutes 11/06/2017 10:16 2 11/06/2017 10:15 2 11/06/2017 10:14 2 11/06/2017 10:11 2...

I need a formula that inserts the word SLAB in column E only if the word SLAB appears in column D, otherwise the existing data in column E remains. I don't want a circular reference, so I can't put a formula in column E (since I need to be able to enter data if SLAB isn't found in D). What...

how to arrive slab from formula for from to condition as <tbody> DATA result formula FROM TO SLAB 1160121 10 - 15 lacs 0 199999 < 2.00 lacs 905440 9 - 10 lacs 200000 299999 2 - 3 lacs 465325 4 - 5 lacs 300000 399999 3 - 4 lacs 1089309 10 - 15 lacs 400000 499999 4 - 5 lacs...

Sir,Need a formula to calculate tax slabs: Up to 2,50,000- Nil <colgroup><col width="35" style="width: 26pt;"><col width="268" style="width: 201pt;"><col width="197" style="width: 148pt;"><col width="200" style="width: 150pt;"></colgroup><tbody> 2,50,000 TO 5,00,000 -5% OF THE AMOUNT...