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 manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History