value as displayed

Hello, I have a column A2 with value "1". I would like the formula in B2 to generate "C1". So if the value of A2 is 1, then B2=C1+5. Where C1 is generated because A2 value is 1. So it is 405. If value of A2 is 2, then use C2 in generated in formula of B2. Formula at B2 will then be "=c2+5". So...

For example: When I click in G5, the formula is: "='Benchmark Inputs '!F18/'Benchmark Inputs '!F10" Instead, I would like to see: $2,398,528,746 / $4,219,000,000 The values can be displayed in H5. My formulas have a variety of general, currency, and percentage formatting. I'm ultimately...

Good Evening. I have a long list of values corresponding to a quantity of color put into paint. I need to convert these according to paint size (1ltr, 2.5ltr, 5ltr etc.) However, once the number of drops reaches 48, I need this to translate to 1 (oz). In other words; 5 x 10 = 50.. this would...

The answer to this question would save HOURS of work every week of my life. So thank you!! The case is, I need to creat a hyperlink to another workbook using only the ID of a client. The ID is a 4 digit number (like 2343) and the adress is always "C:\\Users\samsung\FICHA-2343.xlsx".Only...

I'd like to be able to efficiently read all of the formatted values of a range of cells into an array. When I say formatted values, I mean the values as they are shown on the screen. Range.Value and Range.Value2 can efficiently retrieve the values into an array. Range.Text seems to work only...

Hello Everyone, I have values of what I have in stock in cells C7:C22. I have a formula in cells H7:H22 that calculate start weight minus end weight when are entered into cells D7:D22 and E7:E22. If the value changes in Column H which indicates we used some of the stock on hand I want the...

I have a spreadsheet that pulls date from another file to populate all but 1 column. In that column I need to have a formula that returns one of three responses: If E2 is blank, then keep F2 blank If E2 has a 1, then F2 should say 'single' If E2 has a value greater than 1, then F2 should say...

Hi All, Could you please help me with the following(not sure if vba is needed or a regular function would do it): I have a table like this(with exponentially more data) and on a separate sheet i want to set up a search functionality where in if i enter a specific account number in a cell(for...

For Inventory, manufacturers barcodes are being imported or scanned into Excel, problem is that Euro barcodes bring in sometimes "=" as a prefix to the numerical value skewing what Excel reads, converting the number sequence into a "formula". I want to understand and convey to Excel that it is...

Hello Guys, I've stumbled upon a "feature" in Excel i can't exclude. 1000 0.188 2000 -0.401 3000 0.000 4000 -1.102 When you set the display format for numeric 2digits, Excel changes the Display not the underlying Value Display Value 0.19 0.19...