Hi, I need help with formula to Excel.

I need to create a formula (something like IF) that would show me more options, eg if in Cell A there would be 90,100,110,120,130,140, ​​then in cell B it would be 0.9..1..1,1..1, 2.1,3..1,4..1,5 ...
by

1 Answer

Answer :

either a nested IF function (it goes up to 64 levels, but it's long and ugly) IF functions don't have to nest, but you can join them together using & and return the string = IF (A1 = 90; "0.9" ; "") & IF (A2 = 100; "1.0"; "") & IF (A2 = 110; "1.1"; "") & ... or make an extra vertical table of value pairs and refer to the SEARCH ( VLOOKUP) or use the CHOOSE function, but in this case perhaps just = A1 / 100
by

Related questions

I need advice on a formula to find a specific string in an Excel Spreadsheet and list all cell contents that have that string.

Description : I need advice on a formula to find a specific string in an Excel Spreadsheet and list all cell contents that have that string.

Last Answer : You might be able to use the find function =Find(thing_to_find,source) which returns the position of the thing you're looking for within a string in conjunction with Excel's string functions to extract ... you in the right direction. Agree w/ poster below a more specific example would be helpful.

Anyone know an Excel formula to convert Excel Date/Time to a Time-stamp?

Description : Anyone know an Excel formula to convert Excel Date/Time to a Time-stamp?

Last Answer : Any reason why it has to be a timecode? Could it be a GUID?http://stackoverflow.com/questions/7031347/how-can-i-generate-guids-in-excel

Is there an Excel formula for calculating a length of time and converting it to decimals?

Description : Is there an Excel formula for calculating a length of time and converting it to decimals?

Last Answer : answer:If you are keeping time to the quarter hour, then the decimals are really decimals: i.e., hundredths of an hour. So you don't need a formula. It's simple subtraction, the same ... as you stick to quarter hours and use decimals, those numbers are great tools for several work-related purposes.

How can I apply an excel formula to every seventh line?

Description : How can I apply an excel formula to every seventh line?

Last Answer : answer:I just did this: =IF(MOD(ROW(),7)=0,SUM(A1:A7),0) and it works. your formula doesn’t have anything to do if the mod result comes up false.

Best excel formula to put daily data into weekly data?

Description : Best excel formula to put daily data into weekly data?

Last Answer : Depends on the version of excel If you are using the 2007 version, you can simply use the SUMIFS, AVERAGEIFS, COUNTIFS, etc. functions. Link to MS Explanation If you are using the 2003 version, you will ... 24/09, etc into 10/19/09. This could be done by the DATE function and the WEEKDAY function.

Excel formula?

Description : Excel formula?

Last Answer : you double click on C2. Once inside, write the following: =B2–15 (instead of writing B2, you could also click on the actual cell B2) Then click Enter Then move the mouse over the lower right corner of C2, and once it turns into a +, use it to drag the box until C32 hope that made sense…

Any formula in Excel starts with an …………….. -Technology

Description : Any formula in Excel starts with an …………….. -Technology

Last Answer : Any formula in Excel starts with anequal (=) sign.

What are color coded formula references in Excel?

Description : What are color coded formula references in Excel?

Last Answer : To make it easier to see what parts of a formula refer to whatcells or references on a worksheet, the cell references in theformula are shown in colour and highlights around the cells are inthe corresponding colours.

What is listed in a formula autocomplete list MS Excel?

Description : What is listed in a formula autocomplete list MS Excel?

Last Answer : A list of valid functions, names, and text strings that matchthe letters or trigger that you have begun to type. So if you typethe equals sign and then a letter, functions that start with ... letters, that list will shorten down,maintaining the ones that still match what you have typed sofar.

What are three parts of a formula in excel?

Description : What are three parts of a formula in excel?

Last Answer : what are three parts of a formula in excel

Formula in Excel start with a. % b. = c. + d. –

Description : Formula in Excel start with a. % b. = c. + d. –

Last Answer : b. =

Formula in Excel start with a. % b. = c. + d. –

Description : Formula in Excel start with a. % b. = c. + d. –

Last Answer : b. =

What displays thecontents of the active cell in Excel ? (A) Name box (B) Row Headings (C) Formula bar (D) Task pane (E) None of these

Description : What displays thecontents of the active cell in Excel ? (A) Name box (B) Row Headings (C) Formula bar (D) Task pane (E) None of these

Last Answer : Name box

What displays the contents of the active cell in Excel: a) Name box b) Row Headings c) Formula bar d) Taskpane e) None of The Above

Description : What displays the contents of the active cell in Excel: a) Name box b) Row Headings c) Formula bar d) Taskpane e) None of The Above

Last Answer : c) Formula bar

What displays the content of the active cell in Excel? 1) Name box 2) Row Headings 3) Formula bar 4) Taskpane

Description : What displays the content of the active cell in Excel? 1) Name box 2) Row Headings 3) Formula bar 4) Taskpane

Last Answer : 3) Formula bar

Hi, everyone I'm planning to start my own plowing business in West Michigan. This will be a new adventure for me and I'm in need for some pointers. Please help!

Description : Hi, everyone I'm planning to start my own plowing business in West Michigan. This will be a new adventure for me and I'm in need for some pointers. Please help!

Last Answer : Serious Good customer report seems to be the best thing for I-do-a-service-for-you kind of jobs. Knowing people's first names, being friendly, being prompt especially. People really love having ... phones? It's not as intrusive as a phone call, but good, honest information is always appreciated.

hi i need help plz. i have mine but it doesn't make sense.. can you plz write a half page journal. plz and fast. thank you?

Description : hi i need help plz. i have mine but it doesn't make sense.. can you plz write a half page journal. plz and fast. thank you?

Last Answer : ... (a website I am currently working on for this) Identify what the editorial/opinion is doing: Explain or interpret Criticize Persuade Praise State the writer’s opinion State the main points being made next make ... your opinion.** this is quite a lot I can send mine though Idk how to. thank you

I need help with a 2007 Excel spreadsheet?

Description : I need help with a 2007 Excel spreadsheet?

Last Answer : Ctl-F will open a search window in Excel.

Will a byproduct of a Trump administration immigration policy lead to a need for more homegrown Hi-Tech jobs?

Description : Will a byproduct of a Trump administration immigration policy lead to a need for more homegrown Hi-Tech jobs?

Last Answer : *Drumpf Regime

Hi, I'm new here, any unwritten/unspoken rules I need to know about?

Description : Hi, I'm new here, any unwritten/unspoken rules I need to know about?

Last Answer : answer:Not really. Just respect the guidelines when writing questions. Welcome to ask-public.

Hi,i am looking to travel around Florida for three months and need a base in Clearwater?

Description : Hi,i am looking to travel around Florida for three months and need a base in Clearwater?

Last Answer : Check out this thread (where somebody asked for NYC-apartments). Or go right to this link.

Hi, I need to remove the ix 20, the front grille, I don't know how to do it. I would not like to disassemble "half a car". Thanks

Description : Hi, I need to remove the ix 20, front mask, I don't know how to do it. I would not like to disassemble "half a car". Thanks

Last Answer : Need Answer

Hi! My name is Pitch. Can you help me scratch an itch?

Description : Hi! My name is Pitch. Can you help me scratch an itch?

Last Answer : answer:That's an inflammatory reaction with a possible (probable) secondary bacterial infection. The cause is the hard part of the equation, and you might not ever figure out exactly what's causing it, but ... the counter crap), and put up a barrier to keep the wee-wee away from the scratchy bush.

Hi Jellies! Could you help me with a graduation gift idea for two family members?

Description : Hi Jellies! Could you help me with a graduation gift idea for two family members?

Last Answer : What are their interests/hobbies?

Hi We have neighbors that have a dog that roams, defacates, destroys our trash barks for HOURS pretty darn every night from 9pm - 3 or 4am in the morning. Dont wanna see the dog destroyed because its the owners fault. Help.Lack of sleep is getting to us.?

Description : Hi We have neighbors that have a dog that roams, defacates, destroys our trash barks for HOURS pretty darn every night from 9pm - 3 or 4am in the morning. Dont wanna see the dog destroyed because its the owners fault. Help.Lack of sleep is getting to us.?

Last Answer : If you have not spoken to the owners, you should. It is their responsibility to remove it from your property and away from your things. If not, you can report it.

hi im a single fother of two boys and about to loose everything in my life.and im looking for a govenment grant that can help me get my diploma or ged pleas help with any kind of info thanks ?

Description : hi im a single fother of two boys and about to loose everything in my life.and im looking for a govenment grant that can help me get my diploma or ged pleas help with any kind of info thanks ?

Last Answer : some comunity college's offer free / reduced rates for low income persons. these are for clases that started but are not full. i cut and pasted the following from our local cc website. Unemployed or ... start of the quarter. best regards, No such thing only grants are here www.grant.gov You ca

The number of N-MC groups in alkaloids is best estimate with the help of (A) HI (B) H2SO4 (C) (CH3CO)2 CO (D) CH3 Mg I

Description : The number of N-MC groups in alkaloids is best estimate with the help of (A) HI (B) H2SO4 (C) (CH3CO)2 CO (D) CH3 Mg I

Last Answer : Answer : A

For selecting the entire worksheet in Excel, you need to press ………………. -Technology

Description : For selecting the entire worksheet in Excel, you need to press ………………. -Technology

Last Answer : (b) You need to press Ctrl + Shift + Spacebar for selecting the entire worksheet in Excel.

What sort of training do you need to be proficient at excel?

Description : What sort of training do you need to be proficient at excel?

Last Answer : beng1- Excel is not that difficult to master. First and foremost you need to be proficient in typing and can follow directions clearly. There is no prerequisite required. If you can follow along with the software you should have a competent grasp of the material in several weeks.

Can you help me think through how to set up an excel spreadsheet to create some graphs?

Description : Can you help me think through how to set up an excel spreadsheet to create some graphs?

Last Answer : Excell graph tutor.

Help with an Excel question, I want to center the page on screen?

Description : Help with an Excel question, I want to center the page on screen?

Last Answer : Well, first, in the view tab, uncheck all of the grid lines, formula bars, ruler and headings. Is that more like what you're looking for? Protecting is kind of clunky. First highlight the cells you want to ... It should open up like that for people you send it to. You can practice on me if you want.

Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Description : Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Last Answer : answer:Okay, my answer is gonna get moderated, but this drives me nuts. Every company I've ever worked at, managers all want to use Excel as if it was a word processor. Excel is not a word processor! ... column to become wide), or causing the text to continue to the into the next cell to the right.

Excel spreadsheet help (formulas)

Description : Excel spreadsheet help (formulas)

Last Answer : Which version of excel are you using? In 2010 it has a square root function which is =sqrt(CellNameHere). Also as far as the second problem with the multiplication table can you not just use the cell name for example =$B$1*A2 and then drag it down?

MS Excel Help: Calculate Amount of Time?

Description : MS Excel Help: Calculate Amount of Time?

Last Answer : If your timestamps are in columns A and B, I'd imagine this would do the trick: =B1-A1 and then make sure to set the cell format to time, showing the difference in minutes and seconds. Just tested with this: timestamp A ... = custom: dd/mm/yyyy hh:mm:ss) =B-A: 0:29:57 (cell format = custom: h:mm:ss)

Excel Help - Macros question?

Description : Excel Help - Macros question?

Last Answer : this is the first post on here that i have not gotten a response for within minutes…I am shocked! Have a stumped your guys?

Help: My Microsoft Excel "Paste Special// skip blanks" feature isn't working!

Description : Help: My Microsoft Excel "Paste Special// skip blanks" feature isn't working!

Last Answer : this is probably stupid and fairly obvious, but did you try rebooting your Excel and/or your computer? And when you say the feature isn't working, I assume you mean you check the box for it and ... command? Also, did you try using a brand new spreadsheet and see if the feature is working in that?