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)

x3=2500
x4=7500
I am trying to find the bonus amount to calculate employee bonuses


See More: How to insert formula into excel

Report •


#1
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(A1=2,$X$3,$X$4)

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:

=IF(A1/B1=2,$X$3,$X$4)
Or
=IF(A1*.75=2,$X$3,$X$4)

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