# Questions tagged [worksheet-function]

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

**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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 ...