# Tagged Questions

**1**

vote

**2**answers

19 views

### Single formula to search column and return corresponding fields

Am having issues creating a single formula to search the billionaires list by name and autofill the rank, age, net worth, and citizenship field in the search spreadsheet.
This is the formula I have ...

**0**

votes

**2**answers

5k views

### How to change the text color by a function in Excel 2010

How does one achieve the following:
If (the value of cell A1) < (than the value 0) then (all the text representing the number in cell A1) should be the color (RED)?

**0**

votes

**1**answer

387 views

### Adding percent value in cell to a dollar amount in Excel

I have a column of currency formatted cells (C8:C15) and a markup rate of 15% which is entered into B19. I want to have the markup rate applied to C8:C15. Starting with C8 I entered the formula =B8 + ...

**0**

votes

**1**answer

222 views

### MS Excel pivot table

I have an Excel file: payroll.xlsx
I need to do the following, but I'm not sure how:
Create a pivot table that computes per
employee how many times s/he checked
in and her/his average amount ...