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

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.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History