ExcelBanter - formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula (https://www.excelbanter.com/excel-worksheet-functions/8102-formula.html)

Greg Boyce

formula

I'm sure this is an easy formula for you but I am new to excel.
If A1 is 1 then B1 will be 50, if A1 is 2 then B1 will be 40, if A1 is 3 the
B1 will be 30,etc.
I would appreciate any help, I am not having any luck. Thanks

JE McGimpsey

one way:

B1: =(6-A1)*10

In article ,
"Greg Boyce" <Greg wrote:

I'm sure this is an easy formula for you but I am new to excel.
If A1 is 1 then B1 will be 50, if A1 is 2 then B1 will be 40, if A1 is 3 the
B1 will be 30,etc.
I would appreciate any help, I am not having any luck. Thanks

All times are GMT +1. The time now is 09:59 AM.