single cell formula

Hi, required a formula help to return a correct results, the below stated formula returns a N/A error could you please rectify it...

Hello masters of excel! I work in a data critical career and need to average voltage readings measured across three phases. Typically we do this manually and I'm hoping to average all in a single cell. Example; a. Cell A1 contains the following data "481/485/488" b. Cell B1 outputs the...

Hello, Let's say we have a simple formula of X+Y=Z, where the value of X keeps changing and accordingly the value of Z changes. Now, I

Hello everyone, Hopefully you can help me with this. So i have a list of values (not in any cell) that I need to check against a single value. I want to check if 2 exist in {3,4,6,12,2} and the result would be TRUE or FALSE My intial statement was =2={3,4,6,12,2} but the results comes in...

Hello All, Is it possible to enter two pieces of text information into a cell and have it calculate an answer? For example, I'm trying to make it so an employee can simply punch in a code word for a "job" and have it compile the total time in an adjacent cell. The problem is that I need the...

Hello Everyone, I am asking on some topic which is probably not new, so I did some research, yet my problem didnt solve. Another topic which comes close is this one: http://www.mrexcel.com/forum/excel-questions/496921-return-array-index-match.html Not sure if this would have to be placed in the...

Hi All, I am new to this forum, I have done a search but can not see any posts with the same issue, so here goes. I have multiple documents each with 45+ sheets, 38 of which I need to get data from, I can not edit these sheets but I can add an additional one (summary Page). What I am trying to...

Hi all, I am looking for a single formula that does the following steps: 1. Number (cost) * percentage (fee 1) 2. Number (cost) - Number (answer from formula #1) 3. Number (answer from formula #2) - Number (fee 2) I am not sure how to write that formula within excel. Thanks, Adam