board

Board, I have one more IF statement that I can't figure out. It's below =IF(I9>=0.99,1.5,IF(I9>=0.95,(I9-0.95)/0.04*0.5+1,IF(I9>=0.9,(I9-0.9)/0.05*0.25+0.75,IF(I9>=0.8,(I9-0.8)/10*0.25+0.5,IF(I9<0.8,0)))))*100 The bold part isn't bringing back the right value. I9 is 86.7 and returning 50.2...

I need some help/suggestions with an analysis I am performing based on product serial numbers. Background: I have a spreadsheet of 500 or so serial numbers for one of our electronic products. The serial numbers cover 4-5 different model numbers. Each of these models contains 30-50 pieces of...

Hello All board member, It seems from very very long time on board..Happy to questioning.. Ok.. I have question like, after my c10 range, whatever be the rows data are there, will be clear.. Can anyone help me on this..

Hello Members, I have a file that is imported to my C:Drive from a company system; however, I am only able to import using a xls extension. The imported file exceeds the maximum rows for xls; therefore, it creates additionally data tabs. I need the file to be in xlsx format all in one sheet...

hey so after my amazing first experience of someone answering my question id thought id ask my 2nd question but i think that this is gonna be more complex within my data i have unique Ids for example my title heading is ID , then i have id's such as 1000, 1002 1001 1000 1000 some appear in...

hello guys , i have problem with Vlookup i have a sheet "board" like this B A yes Jack yes Ali no Sara yes Alex no Martin yes Tim and in another sheet i have a list for only Yes then i want list all the names with Yes in the "board" sheet in next sheet want like A...

I want sheet 2 cell b3 to update based on what is elect in sheet 1, this contains list of stores . and sheet2 is a dash board which is already built. So if i click ona value in sheet 1, sheet 2 should show up with dash board based on selection in sheet1 . can someone suggest a suitable vba code

Greetings. I have rounding issue. I'm working with whole numbers, and rounding into millions. For example, the whole numbers are (bold is total): <colgroup><col></colgroup><tbody> (2,339,425) 8,260,205 3,222,786 9,143,566 </tbody> Rounded (using the ROUND function): (2.3) 8.3 3.2...

Hello, I would like to make a digital planning board in Excel. It must look like the old fashioned planning board with paper cards. On the left the project. On top the days of te week. Every day people must be moved (drag and drop) to the projects. I have an excel example that I can email...