Solved How to insert formula into excel

November 15, 2014 at 16:52:51
Specs: Windows 7
In excel how do I insert formula
IF([Perf Rating]=2,$X$3,$X$4)

I am trying to find the bonus amount to calculate employee bonuses

See More: How to insert formula into excel

November 16, 2014 at 05:40:27
✔ Best Answer
I'm not sure what you are asking for.

What is [Perf Rating]?

If it is a value in a cell, such as A1, then you would use:


If it is a calculation based on values in 2 cells or a value in a cell and fixed value, then it might look like this:


Without more information related to what you are trying to do or to what problem you are having, that's the best I can offer.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question