- What does the $ mean when used in a formula please: $G or $3
The use of AI tools (e g chatGPT, BARD, GPT4 etc) to create forum answers is not permitted If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed For the best help attach a sample workbook to your post Attention - ExcelForum Rules have been updated as of August 2023 These rules apply to everyone for the benefit of all, please take a moment now to
- Need excel formula to sum 1+2+3. . . +N given a number N
I am looking for a formula to which I can supply a number N and have it calculate 1+2+3+4 +N I realise that I can enter 1 to N in as many cells then use SUM but this won't do for what I need to achieve
- How to add 3% to a column of numbers in excel? - Excel Help Forum
How to add 3% to a column of numbers in excel?emilio5, Let's say your spreadsheet contains the range D4:D200 and you want to add 3% to each number In column E, or whatever empty column, select cell E4 and type the formula
- conditional formatting with percentage color scale
I have a sheet that calculated percentages I want to set up a conditional format color scale where 0% is green, 50% is yellow and 100% is red However, every time I use the three-color scale and percents, it applies to color scale based on the range of values present, not the full 0-100 range So for example, if I have three cells with 5% 15% and 30%, then 5% will be green, 15% will be yellow
- How do I make and print 3x5 address cards? [SOLVED]
I was in the wrong area when I asked this before I am new at this and trying to figure out how to make a list of names, addresses, phone numbers, etc , that I can then print on 3x5 index cards I want to be able to keep the information in my computer, but be able to print out cards to look it up if I'm not on the computer or to give to my sons who use Mac's instead of PC's I figured someone
- header footer page 1 of x pages [SOLVED] - Excel Help Forum
I would like to add a header or footer to my Excel worksheet printout that needs to shows consecutive page numbers plus the total number of pages on each page Such as page 1 of 12 pages, page 2 of 12 pages, page 3 of 12 pages, etc ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes To vote for this suggestion, click the "I
- Using IF-THEN-ELSE to convert M to Mr, F to Ms ELSE leave Blank.
I used to know how to do this (in my youth, with Supercalc3 and Lotus 1-2-3) and drawing blanks when it comes to Excel 2007 I have a column with my prospects "Gender" - with answers of either "M", "F" or Blank, for Male, Female on Unknown (unverified, actually)
- Strange Dots appearing on screen [SOLVED] - Excel Help Forum
Similar Threads [SOLVED] 3 dots appear before or after the word rather than appearing in the middle of it By alexgoaga in forum Excel Programming VBA Macros Replies: 3 Last Post: 11-02-2018, 09:12 AM
|