Excel Formula

vijaychennai

Board Regular
Joined
Dec 7, 2009
Messages
239
Hello all,

I have exel file in the below format.

Excel Workbook
A
1Hours
22
33
44
54
65
76
829
930
Sheet1



Answer :

Excel Workbook
AB
1HoursAnswer
22
33
44
54
64.14 to 6
764 to 6
82928 to 29
93029 to 30
Sheet1


I required split....
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Drrellik

Well-known Member
Joined
Apr 29, 2013
Messages
770
Office Version
  1. 365
  2. 2016
  3. 2013
  4. 2011
  5. 2010
Platform
  1. Windows
you can set up a table and use vlookup or index(match) if you have much more that 4 arguments, or a nested IF statement like =if(A2<=4,"<4",if(A2<=6,"4 to 6",if(ect... for your arguments) I see you have a 28 to 29 do you have others between 4 to 6 in this answer sheet.

Don
 

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
4,565
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Excel Workbook
ABCDE
1HoursCriteria
22< 4HoursResult
33< 40< 4
444 to 644 to 6
544 to 676 to 27
654 to 62828 to 29
764 to 629.1>29 to 30
82928 to 29
930>29 to 30
10
2b
Excel 2003
Cell Formulas
RangeFormula
B2=VLOOKUP(A2,$D$3:$E$7,2,1)


Edit the Lookup table for your exact criteria and results.

Check Excel's Help for Lookups.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,842
Messages
5,598,394
Members
414,234
Latest member
grlevesq

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top