Miltiple IF formulas in a cell

March 1, 2012 at 17:52:20
Specs: Windows XP
Hi,

Anyway can help with me on this request.


If MC value is 2, how do I equate to 50 points....


MC = 0 >>> 200 points
MC = 1 >>> 100 points
MC = 2 >>> 50 points
MC > 3 >>> 0 point


See More: Miltiple IF formulas in a cell

Report •

#1
March 1, 2012 at 20:31:17
What happens if MC equals 3?

Your example only shows >3.

You should read up on the IF function in the Excel Help file or via Google.

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


Report •
Related Solutions


Ask Question