Formula To Show Users Name
Apr 5, 2007Is there are a formula that will result in showing the users name in a selected cell?
ADVERTISEMENT
Show Users Only Certain Data Based On Their Name
Sep 29, 2006I have a large workbook that contains markbook info of all my classes that I teach.
I don't want them to see all my workbook as it would be too confusing. I would like to hide all the data and have a simple INPUT box on a separate page that would ask for their name. The name would then be used to find the row number, add this to a specific column number (always the same) which hold their marks and then return the mark in a Message box.
Users Of The Spreadsheet Cannot Delete The Formula
Feb 6, 2009I have this formula in my worksheet
=sum (L12*M12*N12)
How can i put this formula into VB code so that users of the spreadsheet cannot delete the formula.
Pivot Tables & Formula: Build A Pivottable And Let Users Move The Fields Around
Apr 28, 2007I'm trying to do at the moment is build a user interface for some Excel Data. Now, the natural way to do this would be to build a pivottable and let users move the fields around, and this is how the thing has worked in previous iterations of the workbook. It seems now, hoever, that we're trying to cater for users for whom pivot tables are just a little too much and to summaries data based on listboxes etc.
What I'm interested in knowing is whether there are ways of interacting with PivotTables beyond the GETPIVOTDATA function - is there any way, for example, to select different field items to show based upon an input from elsewhere? How does one tell a pivottable what to do from outside the pivottable?
Formula To Show Formula From Another Cell?
Jan 14, 2014does such a formula exist? I regularly Change a formula in cell C1. To Show my working I would like to have The formula from C1 written next to it as an equation.
Example: B1 | C1
=Text"updated from formula in C1 automatically" | =x+y*A2
Summarised, is there a formula to Display the formula written in another cell?
Getting A Formula To Show Zero Until It Is Used
Aug 4, 2009I have used excel to create a set of timesheeets and a total page, on the total page there is a column that will show you any varience on your hours each month (I.e if you have worked overtime or under your hours)
I have used the formula =(worked+hours+sick)-(weekly hours*week in month)
This works fine the only problem is in shows a minus number until the hours for that month have been entered so I cant create a total column, is they any way to get these numbers to show 0 until the times are entered?
Formula To Show The Numbers When They Are Below 30
Jun 4, 2009I need a formula to show the numbers as they are when they are below 30, but when they go above 30 I need it to display 30 every time. I have attched a file.
View 3 Replies View RelatedShow The Formula In Cell
Aug 23, 2009I'm trying this code but its not showing the formula in cell Z1, what am i doing wrong here ??
View 2 Replies View RelatedFormula To Show A Change In A Row
Aug 24, 2007I'm working through a huge file and trying to compact it down and make it more workable. I've already managed to get it down to what i need but i now need to add a few things so others can work it more easily also.
One of the ideas i had was the following, but for the life of me i dont know where to start.
The spreadsheet will be updated on a daily basis and at the end of each week we will need to submit any changes we've made to the marketing team.
However the change tracker thats built into excel isn't really what i want.
What i though was i should set up an IF formula that would return a True value if any data in that row was changed.
Then i could set up a macro to copy those rows only to a new sheet to be sent to the marketing team, this way the structure of the spreadsheet would be kept to make it easier for them.
Show Formula As Text
Apr 25, 2006show a formula as text in another cell
View 5 Replies View RelatedOnly Show Formula Result If Not Zero
Nov 7, 2006I'm having trouble with the attached example. An earlier member solved the odd-even problem, but I'd only like it to calculate if there is data in columns B to G.
View 7 Replies View RelatedIf & And Formula: Show The Difference Between Col F And Col G
Mar 14, 2007if the cells in column E AND column F are blank, then column G will be blank also (I dont want 0 showing), if not show me the difference between col F and col G.
I put in the following:-
=IF((E2="")AND(F2=""),"",E2-F2)
However, Excel informs me this is wrong and corrected it as
=IF((E2="")*AND(F2=""),"",E2-F2)
I guess my question is why do I need to put in "*" for this to work?
Show Copied Formula
Sep 7, 2007I have a problem in copy formulas form one cell to another, my formulas are writen in one workbook in this way... '=Dog+Cat.
The problem is that I did a looking table code (vlookup) and when it shows the formula I have #¿Name?.
I would like to knw if there is a way to fix this using the vlookup or I'll be obligated to use special Copypaste
How To Show Minus Value In A Formula As Plus Sign
May 31, 2014I have attached here an excel sheet with some data. I need to show the minus value in D5 as a plus sign, is there any conditional formula to work this out??
View 4 Replies View RelatedFormula To Show Words In Column?
Dec 16, 2013Excel. Let's say this how a column looks like:
a
b
b
c
d
Is there a formula to get this outcome:
a 1
b 2
c 1
d 1
If not, is there a way to create a list of words that are in a column?
Create If Then Formula That Show Value Of Cell In E8?
Jan 29, 2014I am trying to create an "if,then" formula that shows:
if cell E8 is greater than 171, then i'd like cell E9 to show the value of cell in E8.
2 Cells On A Form - Formula To Show If Then
Mar 17, 2014I have a list of customers and each customer has a commission value tied to it. I have a form and in it I have a cell that has a list of customers that someone can choose from a drop down list. If a certain customer is chosen I need their commission value to show up in another cell. example: How do I create a formula to show if Company A is chosen in cell G4 then the commission is 5% in cell G38 , If Company B is chosen then the commission is 8%.
View 9 Replies View RelatedFormula In Cell Show Blank If Zero
Jun 4, 2009I have a spreadsheet which imports data from worksheets week 1, 2 etc to a monthly summary.
Is there any way I can show a cell as blank if the return equals 0?
I'm sure the resolution is probably simple but then so am I.
Formula To Show A Blank Cell When A SUM = Zero
Oct 29, 2009On my spreadsheet i have 4 columns which are in currency format. The 5th column (total) adds the 4 up which currently looks like this - =SUM(BG44:BG45) this shows £0.00 in the 5th column.
What i need is a formula in the 5th column (total) so that when it adds up the 4 previous columns if the sum = £0.00 then the total column should show a blank cell.
Formula Doesn't Show The Date...
Jan 26, 2010I m writing this formula in a cell but i dont receive the result i want...
Formula used... ="Program "&""&G2
(G2 is a Date)
This is te result i get...Program 40210
This is the result i want...Program 1-Feb-2010
If Formula: Show Only What I Need Instead Of Negative And 0 Balances
Oct 12, 2008fix my (if formula) so it includes data from sheet 2. Sunday and monday values change but every other remains the same. I was given this formula and cant seem to add to it. Also is there a way to show only what i need instead of negative and 0 balances?
View 2 Replies View RelatedHow To Use RIGHT Formula To Show Value Until Capital Letter
Dec 29, 2011I was wondering whether it is possible to find a formula in Excel that would extract (using RIGHT formula) surname from Name Surname cell despite surname lenght i.e.:
'John Smith' in one cell would give 'Smith' in the other
'Tom Let' in one cell would give 'Let' in the other
I have tried to combine RIGHT, FIND and PROPER (for upper case) in one formula but it does not work.
Formula To Show Target For Today?
Jan 18, 2012What i have in cell D3 is the formula 'Today ()' to show the date formatted like so. January 2012.
In cells B1,B4,B7,B10,B13,B16,B19,B22,B25,B28,B31,B34 are results showing targets for set each month of the year (B1=January, B2=February etc). What i want to do in cell D4 is show the target for the month that we are in, in other words the target for the month showing in cell D3.
Array Formula Do Not Show Duplicate
Sep 6, 2007I have a range, 2 columns * 5 rows, populated with numbers.
I want an Array formula that it gives back
SMALL (Range, 1) ......
SMALL (Range, n-m), but WITHOUT DUPLICATES
n= 10 , m = # duplicates
¿FREQUENCY, OFFSET.....?
Code To Show The Formula In Comment
Apr 7, 2009i need code to write the formula in comments
for exampe :
when i insert new formula give me the formula in comments. can we do it?
Show Below That Formula Cell In Two Rows
Feb 10, 2010in my document column "L" have some formulas,it's like this.
=150*1.5+25*1.5
i need to make that formula to two part.it's like this.
=150*1.5
=25*1.5
that two part need show below that formula cell in two rows.
Show Formula Result Only If Positive
Aug 23, 2006Is there a way to have a formula return only positive numbers? basically if the result is of this calucation (B4-(B3*B6)-(B6/2)*0.125) is >0, then return the result, if not return "" (or 0).
View 6 Replies View RelatedFormula: Show Nothing Until Data Entered
Oct 21, 2006I am trying to create a simple IF/THEN statement to display profit margin for an order form. I currently have the margin formula set at (1-H14/I14). How should I structure my IF/THEN, to where it displays nothing in the cells, that are empty?
View 5 Replies View RelatedLeft & Right Formula To Show Number Not/as Well
May 22, 2007I have numbers in a cell such as 1/25, 4/31, 12/35 etc I have the current formula to extract the left or right number but when there is only a single digit it also includes the / is there a way of eliminating this.
The numbers vary from 1 to 2 digits.
My current formula is =IF(C15<18,LEFT(E8,2))+IF(C15>18,RIGHT(E8,2))
I only want it to show the number not the forward slash
Formula To Show File Name In Cell
Jun 23, 2008I am trying to get my cell to match the name of the file. I am aware of the following formula: =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5)
This does return what I want, but members of my team often have several sheets open within one Excel window. The formula returns the most recently opened file within the window rather than the name of that particular file. This then distorts my results sheet as it ends up with the name of the most recent file opened rather than the person's name (which is what the file is called)