• 100% Satisfaction Guarantee
Zabo04, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 283
Experience:  Experienced in Word, Excel, Access, Powerpoint, and Outlook.
58597962
Type Your Microsoft Office Question Here...
Zabo04 is online now

# I need to configure a formula in Excell 2007/2001 that will

I need to configure a formula in Excell 2007/2001 that will take a number (1-10), assign a value of 80 as a baseline for the number '1' and increment that value by 20 if the number is XXXXX another 20 if the number is XXXXX etc.

The end result needs to be 80, 100, 120, 140, 160...for the value of 1,2,3,4 and 5...

Any help with this is welcome.

Zabo04 :

is the number (i.e., 1, 2, 3, etc.) in a cell?

Zabo04 :

If that number where in a cell (say cell A4), the formula would be =80+(A4-1)*20

Zabo04 :

for 1 in A4: 80+(1-1)*20 = 80

Zabo04 :

for 2 in A4: 80+(2-1)*20 = 100

Zabo04 :

If no cell specifies the number then you could use a different method. If this column (say column A) of your table starts at row 4, so A4 is the first cell, enter 80 into cell A4.

Zabo04 :

In cell A5 enter =A4+20

Zabo04 :

copy and paste the formula in cell A5 down the entire column and every row will increment by 20 from the previous row

Customer:

Hi Zabo04,

Customer:

You really know this well. Thank you for getting me started with the right answer and approach.

Customer:

Thank you,

Customer:

Chuck