Jul 06 2022 06:19 PM
Looking for a simple excel formula, if cell value is 1 then = 50, if cell value is 2 then = 45 etc ?
Jul 06 2022 06:57 PM
Jul 07 2022 07:55 AM
@Stevej4515
Depends on what the "etc" exactly means
Jul 07 2022 08:12 AM
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)
