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 ?

@Stevej4515 

Depends on what the "etc" exactly means

@Stevej4515 

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

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

 

=55-5*A2

 

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

 

=MAX(55-5*A2, 0)