What is Excel formula

Occasional Visitor

Looking for a simple excel formula, if cell value is 1 then = 50, if cell value is 2 then = 45 etc ?

3 Replies
ohh is it the formula of pivot table calculate field ?


Depends on what the "etc" exactly means


Let's say the cell with the value is A2.

In another cell, e.g. in B2, enter the formula




If you don't want the value to become negative if A2 is larger than 11, use


=MAX(55-5*A2, 0)