hand

hello all, i need hand on a IF+AND formula, how can i amend it with my request? =IFERROR(IF(AND(--LEFT(C59,5)>=--LEFT(B59,5),--RIGHT(C59,5)<=--RIGHT(B59,5)),"","WRONG"),"") is it possible to return one more request with "NO GIVEN" when it encountered "#N/A" thanks, have a great day

Hey friends. Not sure if this can be done but here is what I want to accomplish. Our store's inventory will happen soon. Our old style of doing inventory is slow and I want to streamline this process. Our point of sale system allows me to export all of our inventory items, which includes the...

Excel 2016 (Windows) 32 bit <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>#E0E0F0[/URL] "]...

I am using a Spreadsheet as a form. Currently my people are printing out the form and hand writing the data in to the cells. I was wanting to speed things up. We have 2 exported reports that could be used to fill in the data fields and ranges. Currently I've been cutting and pasting the data...

I am trying to put a string into my formula (which I know would need double quotes). However the formula is already the cell value, please see the below. Cel.Offset(0, 3).Value = "=""String "" & Cel.Offset(0, 3).Value" The Cel.Offset(0,3).Value on the right hand side of the = sign is...

A friend of mine is doing simple sums of cells, but in certain cells in that range a small triangle appears in the top left hand corner of that cell. Whatever you input in those cells do not add up in the results cell. Their is some form of strange formatting happening here, Any ideas ?

I've got a spreadsheet which has been very reliable over the past few years. However, recently is has become a little unstable and periodically crashes for an unknown reason. I think it might be related to conditional formatting that has slowly gotten out of hand as rows have been copied and...

Trying to use this formula however I am getting an "error with formula". =IFERROR(AVERAGEIF(K25:O25,”>0”),”0”) Maybe someone can lend me a hand with this? Thanks, PuJo

Hi Is it possible for me to handle receipt allocations to a loan in excel or access? <colgroup><col><col><col><col><col><col><col><col><col><col span="3"><col><col span="2"><col><col></colgroup><tbody> Borrower Name Agreement Number Transaction Reference User Agreement Date Repayment Method...

Hi All, I need a formula that provides the date inventory will run out based on a quantity on hand and a demand forecast. I'm assuming an array function will be necessary. I would like to assume that the demand per month is evenly spread per day. For example, Item 123A has 500 units on hand...

I have 2 sheets . One that shows me a part number description and qty on open orders at I have through a pivot table . I have another sheet for my inventory that shows Part number description and on hand qty. I want to do a vlookup on the open orders to show me how many I have on hand to fill...

Hi there, I have a userform which has a large amount of user inputs on the left hand side. There isn't much room and everything is a bit small and difficult to operate. The right hand side of the userform has some other controls which need to be visible at all times. Is it possible to embed my...

Hi all. I have the following formula in a sheet I update each month: =IFS(TEXT(NUMBERVALUE(P2);"00")="01";'K:\MD\_data\Fim do Mês\Data\2019\2019-01\[Orders On Hand 2019-01.XLSX]Sheet1'!$N$2/1000;TEXT(NUMBERVALUE(P2);"00")="02";'[Orders On Hand...

Hello- i have an excess inventory on hand which i need to figure out which part to keep and which part to destroy. my goal is to get a formula that will give me the desired output for the column in red font (destroy the rest). I have done a few scenarios to hopefully explain this better. As...

Hello, I would like a function that would output the years on hand by group max column based on the estimated years on hand max column. I have been able to complete the function by doing If, And statement, however it is a long formula. Is there a shorter way to complete with a range...

Hi I selected cell A1. I want to go to cell A2. I used the down arrow, but to my surprise, it wont move to A2 but the whole sheet will go down (it is like I am screwing down using the screw bar in the right hand side). Why this situation happened? Thank you very much.

<colgroup><col><col><col><col></colgroup><tbody> Store Average Daily Sales Inventory Days On Hand (Inv/Sales) New York, NY 20 40 2 Seattle, WA 25 200 8 Detroit, MI 75 225 3 Dallas, TX 5 50 10 Total 125 515 4.12 </tbody> How to calculate what each stores weight is in the aggregate...

Hello, everyone, I'm trying to concatenate several cells into one if it matches a certain criterias. I was wondering if you could lay me a hand. Below you will find a file with a simple example: https://ufile.io/9e7ht Thanks!

Need to run a loop that takes data from one sheet and put the data onto another. Sooo on the new sheet C3=B5 D3=C5 E3=D5 F3=E5 C4=H5 D4=I5 E4=J5 F4=K5 C5=N5 D5=O5 E5=P5 F5=Q5 ... C16=CN5 D16=CO5 E16=CP5 F16=CQ5 Left hand side is new sheet and right hand side is like worksheet1 All in the...

Good afternoon, Here is a sample spreadsheet for which my questions will be related: A B C D E F G H I J K <tbody> Hand No. John Susan Nick Jane Nancy Sarah Mary Robert Math Check...