Forum Discussion
What is Excel formula
Looking for a simple excel formula, if cell value is 1 then = 50, if cell value is 2 then = 45 etc ?
3 Replies
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)
Depends on what the "etc" exactly means
- ohh is it the formula of pivot table calculate field ?
