Most valuable professional
  • Hot Topics

Excel Easy way to make an IF

I'am kinda new at using If. Is there a easy way to make a very long one? What i want to do is.... if A1 is 200 then do A2 * 0.50 But if its 300 then do A2 * 0.75 but if it is 400 then do A2 * 0.6 and so on.... for about 30 ifs...

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of April 10, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel