software

hi trying to wright a if formula eg if b1=1 then (c2*d2 e2) if b1=2 then
(c2*d2)

Hello All,

How can i use the RANK function or any other functions on criteria from two
columns. One column in descending order, the other in ascending order.

i want to calculate the average of a row of numbers then add it to a

I would like to set following conditions in Excel, but find it difficult on
coding.

I would like to customize the formatting of the pivot table I have created.
Add colors, grid lines, etc. However, each time the data is refreshed, the

I am not sure how this happened, but everytime I open a particular workbook,
it simultaneously opens another one. The workbook file that I want to open

After pasting data into a new Excel column, I need to limit the new Column to
first 2 characters only.

I have created an Expense Template for associates to use. All formulas are
protected and some cells are unlocked so they can make entires. Every once

Hi. I have a financial time series (a two column array consisting of the
columns 'date' and 'price') containing weekday values of a stock price.