Excel Formula If Statement - in between percentages
Here is what I am trying to do:
I have one column (lets say Column A) of percentages (ranging from 100% to 0%). I have a second column (lets say Column B) with a number 1-10. I want to create a third column which adds together whatever number is in Column B, and the following: If the percentage is 99-90, add 1. If 89-80, add 2. 79-70, add 3. 69-60, add 4. 59-50, add 5. 49-40, add 6. 39-30, add 7. 29-20, add 8. 19-10, add 9. under 10, add 10.
However, I can't seem to write it properly. Any help would be greatly appreciated.
Here's how I would go at it. Assuming you are using columns A and B, and data starts on row2.
=B2+IF(A2<0.1,10,IF(A2<=0.19,9,IF(A2<=0.29,8,IF(A2<0.39,7,IF(A2<=0.49,6,IF(A2<=0.59,5,IF(A2<=0.69,4,IF(A2<=0.79,3,IF(A2<=0.89,2,IF(A2<=0.99,1))))))))))
Also worth noting that you stated the percentages would be from 0% to 100%, yet 100% is not part of any of your data forks.
Hope this works!
- List only workdays in given dynamic month
- How to read SharePoint Online (Office365) Excel files into Python specifically pandas with Work or School Account?
- Difference between .Delete and .Clear in Excel VBA?
- Merging cells in Excel using Apache POI
- Having issues not including duplicate words randomly populating 3 columns in Excel
- Excel: Filter a sheet from value in another sheet
- Merge two cells keeping/adding formatting
- Output all cell colors from a range in Excel using Office Scripts
- Using EPPlus with a MemoryStream
- Creating an office script where it looks at the first column in each sheet and inserts a column based on the value in the first column
- Putting a concatenate inside of a count if
- GetMyFeesEstimate API Amazon vba
- "The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns" Error
- Excel fill numbers within a range
- VBA isString vs isNumeric
- How to use a cell range to color another one?
- Macro Help: Workbook to New Doc Copying Only the Cell Values
- Date format issue when I try to find the first occurrence of names with associated dates
- Excel VBA Autofilter Values Not Equal To Asterisk (*)
- How do I check If autosave is on and then switch it back on if it is not?
- Driving Excel from Python in Windows
- VBA Excel Cannot open external workbook
- TypeError while using Openpyxl to read file
- Excel VBA to hide rows if more than 10 blanks
- I have a list of lat/long points of interest, and lat/longs for public trans how to find addresses with have all three public trans?
- Excel: how to search by two rows and one column
- Excel to Word VBA The formatting does not apply to the correct text
- Select some adjacent and non-adjacent column ranges and save to pdf as if they were all adjacent
- How do I convert a single vertical row into multiple row array in Excel?
- Excel - Check existing digit count, if <10 then add prefix "100" to make it 10 digit