1
vote
2answers
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
2answers
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
1answer
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
1answer
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 ...