Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [worksheet-function]

Questions about using in-cell functions/formulas in spreadsheet software.

0
votes
0answers
8 views

How to maintain Excel-file xlsx -formulae when opening on Chromebook? [on hold]

I have tried now all possible applications: XLS editor/viewer Excel Online But none of those maintain the formulae. They show only the absolute numerical values. Opening the file in Windows, I ...
0
votes
1answer
15 views

Excel: check multiple cells for specified values, name the ones that do not match

Ok, so I've tried writing my own formula to make this doable but am drawing a blank. I want to check multiple columns in a row to see if they contain a specifief value, let's say "V". Then in the ...
0
votes
1answer
34 views

Excel: Conditional formatting if cell is not equal to one of multiple values

Using Excel, I would like to conditionally highlight a cell, if the value of the cell itself is not one of several values. The cell should be contain of the following percentages – 0%, 6%, 12% - or ...
0
votes
1answer
23 views

Not using a cell as variable, whilst inserting a (excel-)formula in several cells

I'm facing a small, basic little problem, for which I can't find the solution: I'd like to insert the same formula in several cells at once. Quickly googling this problem provides a solution: Either ...
0
votes
1answer
25 views

Excel: How to generate dynamic tables, based on values of another table

In Excel, I would like to generate a dynamic table, based on the values in some other cell. I have never done this before, so I don't know the terminology or the techniques involved. I'm also not ...
-1
votes
0answers
22 views

How to add column and function in that column in web page [on hold]

i just working in online and the work status are displayed in the same page. I would like to add some of column to calculate the payment status. At the last i need to add column and formula for ...
1
vote
1answer
21 views

Subtraction + modified result if negative

How do I set up a formula which will subtract one cell from another (ex: B2-B3) and return the usual result, UNLESS the result is negative (basically < zero), in which case I need it to return "$0....
0
votes
2answers
27 views

Converting column values to range from 1-100

My dataset contains population size for different states. Is it possible to convert them to a scale of 1-100. Andaman And Nicobar 598 Andhra Pradesh 1,837 Arunachal Pradesh 1,178 Assam 2,228 ...
-3
votes
1answer
27 views

IF functions and results

I am looking to create a formula for 2 columns. The formula will check if the first column has a value greater than 1 and if the answer is yes it will then execute A1-B1 and show the answer. If the ...
0
votes
0answers
26 views

Format a cell to fit the contents within it (excel)

I am attempting to format a cell within Microsoft Excel with an image in the cell, but when formatting the cell to fit the contents, it will not properly fit. I have a spreadsheet that instructs user ...
0
votes
1answer
31 views

Formula to ignore or treat as empty a cell that contains another formula with no result?

I'm using Excel 2007 I have a Cell B14 which contains a formula getting data from a different worksheet and sometimes this formula may have no result. I need a formula to ignore Cell B14 or treat it ...
-1
votes
2answers
42 views

VLOOKUP for a range of letters

I need to take a range of letters for example: if the cell contains A, B, C, or D and fill a cell with P1. If the cell contains E, F, G, or H fill a cell with P2. If the cell contains I, J, K,or L ...
-1
votes
0answers
28 views

Excel Formula referencing IFERROR with blank gives #VALUE error

I have come across an issue with using IFERROR to return a blank. When I have another cell referencing this blank one to SUM values I get a #VALUE error in that cell. I assume it is because the "" ...
0
votes
1answer
38 views

IF function with two logical tests

I need help with creating a formula with two logical tests. I got the first one but can't figure out how to include the second logical test. My formula currently: If column E=S, I want Annual Salary ...
0
votes
0answers
80 views

Formula across sheets dependent on value on each sheet to include or not in Apple iWork Numbers

I am tracking my options trading, and as each position can span multiple transactions over time, including across year boundaries, I track each position from start to close on its own Sheet. I name ...

15 30 50 per page